2009-11-13

Viewing "Standard Reports" in SQL Server 2005 Management Studio for non-SA users

The "Standard Reports" in SQL Server 2005 Management Studio are pretty neat, but I was surprised to find that other power users who were granted access to the server had the entire "Standard Reports" item missing from their context menus. It should have looked something like this:


but instead they got this:



I couldn't find anything about what permissions the user needs in the official documentation, but finally found a mention of "VIEW_SERVER_STATE" permissions relevant to this. Granting the users' logins this right seems to have solved the problem - with the caveat that there could be security implications of granting normal users a right that is normally reserved for the sysadmin:

No comments: