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.