Solved

Applying SQL server view any database permissions

Posted on 2014-07-22
2
74 Views
Last Modified: 2015-08-20
I granted a new user "View any database" permission which should allow him to see any of the database's metadata. But when I select database > properties, I receive the error "Cannot access due to current security context."

According to technet:
A login that is granted this permission can see metadata that describes all databases, regardless of whether the login owns or can actually use a particular database.

What am I doing or assuming incorrectly?
0
Comment
Question by:barnesco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
Philip Portnoy earned 500 total points
ID: 40212181
There's a new layer of security in SQL 2005+ compared to SQL 2005.

You need to grant view definition.

USE master 
GO 
GRANT VIEW ANY DEFINITION TO User1

Open in new window

0
 

Author Comment

by:barnesco
ID: 40212324
Actually, he has that permission, too, and view server state.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question