Link to home
Start Free TrialLog in
Avatar of barnesco
barnesco

asked on

Applying SQL server view any database permissions

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?
ASKER CERTIFIED SOLUTION
Avatar of Philip Portnoy
Philip Portnoy
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of barnesco
barnesco

ASKER

Actually, he has that permission, too, and view server state.