Showing posts with label Profiler permission. Show all posts
Showing posts with label Profiler permission. Show all posts

Sunday, October 5, 2014

Run SQL Profiler without Sysadmin permission

many times, developers ask permission to run SQL Profiler/Trace. you can grant below permission to run SQL Trace/ Profiler

USE [MASTER]
GO;

GRANT SHOWPLAN to [AD\User]

GRANT VIEW SERVER STATE to [AD\User]

GRANT ALTER TRACE to [AD\User]