Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Grant user access to a single Databse

Author  Topic 

dimepop
Starting Member

33 Posts

Posted - 2013-04-17 : 05:16:01
Hi, i have a SQL 2012 server with multiple DBs.
I want to grant a Domain user access to query 1 single DB.
I have granted the user public access to the DB.
When he logs on to SQL management studio he can see all the DBs but has no access to them.
Is there a way to prevent him from seeing all the other DBs?
Is public role the right role if i only want him to be able to query? not delete, modify anything?
thanks

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-04-17 : 08:58:00
See this thread in regards to preventing the user from seeing databases s/he does not have access to. (No good solutions suggested there) http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=183527

If you want the user to be able to read the tables, add them to the db_datareader role.
Go to Top of Page
   

- Advertisement -