We have several databases on SQL server.
We would like to create 1 new user that can see database 'c' but can not see the rest of the databases.
This user should only be able to select from this database, and nothing else.
I have been googleing and searching for a while now, and the closest I found was to deny view any database, and then make them the database owner.
But I don't think that will work for limiting them to select, unless is there a way I can
deny everything except for select on a database owner?
Thanks in advance for any help!
Edit: SQL Server 2008 R2, by the way.
Edit2: Sorry, I was not clear in my original post. I am looking to make it so when they log in they won't even see the names of other databases, not just that they can't access them.