SQL
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]
Home
Subscribe to:
Posts (Atom)