Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.