July 26, 2010 at 12:50 am
Hi All,
I have 4 databases by names DB1,DB2,DB3,DB4.
I created one user( Login : TestUser ) & granted access to database DB4. when logingin through TestUser I am able to see all databases. When I accessed DB1,DB2,DB3 getting error message as expected like " The database DB1 is not accessible."
Is there any possibility to hide the databases from viewing to the user for which the user is not having access.
Thanks for the help 🙂
Pavan K
July 27, 2010 at 10:51 am
Right click on Your server -> Goto Permissions -> select the account that you are running and go to View Any database -> Click on Deny permission.
Regards
Hema.,
July 27, 2010 at 11:13 am
But that would also deny the DB he needs, though, right?
July 27, 2010 at 12:25 pm
I think that will remove all databases.
AFAIK, there is no way to prevent all the databases from appearing. They are all stored in a table in SQL and SSMS reads the table. There isn't row level security.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 27, 2010 at 8:35 pm
VIEW ANY DATABASE permission is a new, server-level permission. A login that is granted with this permission can see metadata that describes all databases, regardless of whether the login owns or can actually use a particular database.
Please note By default, the VIEW ANY DATABASE permission is granted to the public role. Therefore, by default, every user that connects to an instance of SQL Server 2005 / 2008 can see all databases in the instance.
July 28, 2010 at 1:32 am
that was Helpful information.
Thanks all for your time.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply