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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-10-26 : 13:24:53
|
| One of our user needs to have read access to one user database.SO I created SQL login(mixed mode) and granted read access on db.User Installed SQL 2005 on his machine and remotly able to connect to SQL server and read the data from db. He don't have access to other user databases including MSDB,Model.But, He has the access to master database. How to restrict the user from accessing master dbPlease advice |
|
|
vna_mhars
Starting Member
37 Posts |
|
|
|
|
|
Login