View Any Database
The instance level View Any Database permission takes precedence over assigning more granular securables; this permits a user to view all databases in an instance, not just those databases for which the user has permission.
Upvotes: 11<=-=Nov 5 2010 7:16AM=-=>
I agree that we need more granularity. Servers are holding greater numbers of databases, and the importance of masking groups of databases for admin purposes is growing. Currently, if the “ANY” permission is not granted, the principal must be the database owner (or highly privileged).
A database level VIEW DATABASE permission would enhance manageability.<=-=Dec 13 2010 5:02AM=-=>
Thanks for the suggestion. This is something that we have been thinking about and we’ll consider this for a future version of SQL Server.
Thank you for your feedback. We will consider this for a future version of SQL Server.
SQL Server Engine
Thank you for your feedback. We will consider this for a future version of SQL Server.<=-=Jun 25 2015 12:35PM=-=>
agree with Michael Smith. Currently if deny view any databases, users can only see the databases they are direct owner, not the see databases that they have access in Object explorer.