up vote 0 down vote favorite
share [g+] share [fb]

I have a Server with 10 database, I need to have a user that can only see one database with read-only permissions to all tables.

I create the user, Assign public row in the server and assign db_datareader to the user in the database that I want. Is this enough, Do I have to do something else? How to I hide the other databases, I don´t want the user to know that I have another databases in the same server.

He will be using Microsoft Sql Server Management Studio to access de database.

link|improve this question
100% accept rate
Make sure the default database is not master and also make sure the user doesn't inherit elevated privileges from a group. – DaniSQL Jul 22 '10 at 15:27
Default database is correct, How do I see the elevated priviliges? – Jedi Master Spooky Jul 23 '10 at 13:24
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.