Restrict specific users to any be able to see specific databases on the same instance??? Help....

Question

We Have several Databases on the same instance and we would like to be able to set up different users to only be able to view and control specific DB's assigned to each specific User. We have managed to restrict users to only be allowed to control certain DB's but they can still see all of the other DB's on the instance via Management Studio. 

Does anyone know if this is at all possible and/or if there might be a different way to achieve the same result?

Any help would be very much appreciated been going round in circle for several days now. 

 

Answer 1

Please check this article in Books Online: http://msdn.microsoft.com/en-us/library/ms189077.aspx 

This article describes the VIEW ANY DATABASE permissions. This is by default granted to public. But you can deny this. Then users will only see the databases they own.

 

---

Robert Hartskeerl - http://sqlblog.hartskeerl.nl - http://twitter.com/rhartskeerl

Answer 2

What you are trying to do is partly impossible with current SQL server security architecture when you revoke view any database from public the logins might not be able to see other databases than master and tempdb though they have access to user database , see my reply from SQL security forum thread http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/64aa6538-5f57-491b-9c53-4a103ae71637

---

Thanks, Leks