Solved

Applying SQL server view any database permissions

Posted on 2014-07-22
2
67 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

726 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