Search

Thursday, July 28, 2011

Grant rights to run profiler in sql 2005

In Sql server 2005 we finaly can grant users the right to do traces, Note! traces does hurt the performance so this is not an right the users should have permanently! For specific task we can grant it but on the first place the tracing should be done by us. We can grant this right for users for a limited period of time

GRANT ALTER TRACE TO [domain\username]

To be bale to se use t.ec sp:who we can also grant this right:

GRANT VIEW server STATE TO [domain\username]

No comments:

Post a Comment