October 26, 2010 at 11:23 am
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 db
Please advice
October 26, 2010 at 2:24 pm
Revoke the permission on master database. Grant permissions on the requisite database make it the default database for that login
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 27, 2010 at 8:02 am
Hi Pradeep, Thank you for your reply.
Can you please guide me how to do from SSMS or any script is there.
Appreciate your help
October 27, 2010 at 11:10 am
In SSMS, expand server | expand Security | expand Logins | right-click on user ID | User Mapping
Hope this helps.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply