How to hide the databases among no of dbs for particular user

Last post 08-29-2008 4:42 AM by rohit2900. 3 replies.
Page 1 of 1 (4 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 08-12-2008 2:05 AM

    How to hide the databases among no of dbs for particular user

    HI all,

    i want to provide database access to the client.But in my production database server i have more than one database.just i want to display only single database among the other databases.
    similarly i want to display few tables among the no of table object.Please can any one suggest this where i can find this option to restrict to specific objects for the user.

    Thanks,
    Thulasi.

    Filed under:
  • 08-12-2008 2:21 PM In reply to

    Re: How to hide the databases among no of dbs for particular user

    Not possible. You can deny access to unauthorized people but cannot prevent it from showing in the object explorer.

    ***********************
    Dinakar Nethi
    Life is short. Enjoy it.
    ***********************
    http://weblogs.sqlteam.com/dinakar/
  • 08-28-2008 2:44 AM In reply to

    Re: How to hide the databases among no of dbs for particular user

    Hi,

     Why you can't try the View definition permission.

    Cheers,
    Prabhakar
  • 08-29-2008 4:42 AM In reply to

    Re: How to hide the databases among no of dbs for particular user

    In Management Studio, right click the server then click "Properties".  Click on "Permissions" and then select the "Public" role and remove Grant from "View Any Database".  I'm not sure if this will achieve what you're looking for but it's how to remove that permission.

    But I'll suggest you should do it at the login level....

     

    Rohit Paliwal
    MCDBA
    View Rohit Paliwal's profile on LinkedIn
Page 1 of 1 (4 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.