SQL

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]
Posted by Adi Gadani at 6:19 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: ALTER TRACE, Profiler permission, SHOWPLAN, SQL Profiler permission, SQL server permission
Newer Post Home

About Me

Adi Gadani
View my complete profile

Blog Archive

  • ►  2022 (2)
    • ►  October (1)
    • ►  February (1)
  • ►  2018 (3)
    • ►  November (3)
  • ►  2016 (1)
    • ►  August (1)
  • ►  2015 (1)
    • ►  March (1)
  • ▼  2014 (8)
    • ▼  October (8)
      • DELETE millions of records in batches
      • script out db object and db level permission
      • script to find out object level permission
      • Validate sql script before deployment
      • Stored Proc VS User Defined Functions(UDF)
      • Difference between View vs Materialized View
      • generate script to rebuild index for all tables
      • Run SQL Profiler without Sysadmin permission
Simple theme. Theme images by gaffera. Powered by Blogger.