DBA - Permissions To Execute SQL Server Profiler

Below code can be used to provide/revoke Permissions to user to run SQL Server Profiler.

USE MASTER
GO
GRANT ALTER Trace TO [DomainName\UserName]
--Grant Permission To Aamir To Run Profiler
GRANT ALTER Trace TO [MyDomain\Aamir]

--Revoke Permission For Aamir
REVOKE ALTER Trace TO [DomainName\UserName]
REVOKE ALTER Trace TO [MyDomain\Aamir]

No comments:

Post a Comment