Post reply

Restrict view so user can only see databases related to them

  • November 25, 2011 at 4:13 am

    #260594

    Is there any easy way to restrict a user to only be able to see the databases that they should have access to?

    I restrict view databases to public and grant view to the individual user as required but I would like an easy way to just allow the user to only be able to seetheir database if possible, through SSMS for instance. The user does not have access to see anything in the database but I would also like to hide this from them if possible.

    Thanks

    Taggs

  • November 26, 2011 at 7:45 am

    #1413109

    This question comes up a lot and there's no easy way (or supported way) to do this. If you revoke VIEW ANY DATABASE from public, then the users in questions would have to be owners of the databases in question, which isn't acceptable.

    This is currently a limitation in the security model within SQL Server. It has been proposed to have this fixed in later versions, but thus far, I believe the behavior is still the same throughout.

    K. Brian Kelley
    @kbriankelley

  • November 28, 2011 at 2:13 am

    #1413276

    OK, thank you for taking the time to reply.

    Taggs

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply