How to run SQL Profiler without sysadmin rights?

In SQL Server 2000, to run SQL Profiler the sysadmin needs to grant permissions to the user running the trace. In SQL Server 2005 and 2008, the option exists of granting permissions to Profiler so that users do not need to be a member of the sysadmin group by using the code below:

USE master
GO
GRANT ALTER TRACE TO username;
GO

If the permission needs to be revoked, use the code below:

USE master
GO
DENY ALTER TRACE TO username;
GO




Array

No comments yet... Be the first to leave a reply!