July 28, 2009 at 1:00 am
Hi,
I have a SQL server 2005 with 15 databases, and I want to create a SQL login where the user will have access to only 1 of those databases.
I can set up those permission with no problem, but I want the list of databases to be filtered.
When he opens management studio, I want only the 1 DB he has access to, to be listed - not all the other 14 DBs.
Is that possible?
July 28, 2009 at 2:11 pm
I don't believe this is possible. However, if the user does not have permission, they won't be able to access the other databases.
July 28, 2009 at 2:23 pm
"Is that possible?" No, restricting the list of database displayed by SSMS is not supported. There are many requests to restrict the list of databases to only those accesable by the login at connect.microsoft.com/sqlserver.
SQL = Scarcely Qualifies as a Language
July 28, 2009 at 4:17 pm
Yes, this is possible.
Go to
LOGIN properties --> securables ---> click add ---> add objects SERVER ---> find view ANY DATABASE and mark DENY.
This is my only idea.
Best regards,
July 29, 2009 at 2:40 am
FYI: If you "DENY VIEW ANY DATABASE" for a login, under the SSMS object browser, only the master and tempdb databases will appear.
SQL = Scarcely Qualifies as a Language
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply