Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

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.

5 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
unplanned  ·  AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded  · 

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=-=>

Hi Grant,

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.

Thanks,
il-Sung.

<=-=Aug 30 2011 11:38AM=-=>

Hi Grant,

Thank you for your feedback. We will consider this for a future version of SQL Server.

Regards,
Don Pinto
SQL Server Engine

<=-=Feb 11 2013 2:38PM=-=>

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.

0 comments

Attach a File
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

SQL Server: Suggestions

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice