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.
| 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=183527If you want the user to be able to read the tables, add them to the db_datareader role. |
 |
|
|
|
|
|
Grant user access to a single Databse