Home Dashboard Directory Help
Search

SSMS - Revoking VIEW ANY DATABASE from Public Role by Phil Brammer


Status: 

Active


4
0
Sign in
to vote
Type: Bug
ID: 774373
Opened: 12/14/2012 8:51:27 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Revoking the permission, VIEW ANY DATABASE, from the Public server role causes SSMS to show only tempdb and master, even if a login has access to one or more databases.

For what it is worth, the query SSMS is running against the DB correctly returns the database(s) the login has access to, but SSMS is not showing it.
Details
Sign in to post a comment.
Sign in to post a workaround.