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