Posted - 09/24/2012 : 16:46:36
IN SQL 2008/2012 is there any way to make so a user only can see the databases that they have access to.
I have tried the following
Deny View any Database to Public
Deny View any Database to User
When I do the above all I see is the Master and Tempdb.
How do I change so the user can see the database they have access to.