July 22, 2010 at 7:35 am
Hi,
I am a SQL administrator and have full access to a 2005 SQL server. I have created a new user that I want to be able to access there database and only their database via, Management Studio Express and their own connection strings for their code.
I have managed to give them access through Management Studio Express but they can see all our other databases too, they do not have permission to access them but they can see them and other user accounts.
I found this below but it removes access to all the databases so they can't see theirs.
Any help on this would be great. Thanks
use master
Revoke View any database from public
go
July 22, 2010 at 8:28 am
I don't believe that there is way with the securables to only allow viewing of certain database names in the list. Therefore, you'll need to restore the VIEW ANY DEFINITION permission back to public. Otherwise, no one short of members of the sysadmin role or those with CONTROL SERVER rights will be able to see the list of databases.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply