July 30, 2009 at 9:22 am
Hi,
I need to create a login where in the user should be able to view only a particular DB. Not all the DB's should be visible to him. Also he should be able to just use the select statement and run only one particular query.
I have created a login and have set the permissions but only concern here is when the user logs in, he is able to see all the Database. When he tries to other Databases, the user does get an error.
Can i avoid the other DB being visible ? Also let me know the best practice to set permissions for users.
REgards
krishna
July 30, 2009 at 12:00 pm
This thread describes a way to do this. Although I haven't had a need for this and haven't tried it, I think it's worth you consideration. http://www.sqlservercentral.com/Forums/Topic678099-146-1.aspx
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply