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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774373 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/14/2012 8:51:27 AM
Access Restriction Public


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.
Sign in to post a comment.