Thursday, February 12, 2009

Running SQL Profiler without sysadmin Privileges

In SQL Server 2000, if you wish to run SQL Profiler you need grant sysadmin permission to the user. This was not encouraging for the system administrators.  In SQL Server 2005, you have the option of granting permission only for SQL Profiler, so that the users should not be a member of sysadmin group.

USE master
GO

GRANT ALTER TRACE TO username;
GO

In case you need to revoke the permission, you granting permission only for SQL Profiler.

USE master
GO

DENY ALTER TRACE TO username;
GO

No comments:

Post a Comment