Search

Wednesday, July 27, 2011

Grant users right to use performance dashboard

By default users can use performance dashboard. Sometimes we need to grant users that right when we are trouble shouting or the user owns their own server. We do not like to give them sysadm right so insetad we can grant them the minimum rights needed to use performance dashboard.


Those are the rights needed:

GRANT VIEW server STATE TO MyUser;
go
GRANT ALTER TRACE TO MyUser;

The second part gives the possibility to create and view traces.

No comments:

Post a Comment