Permissions to perform SQL Profiler / Trace

• paul.farnell

  SSC Eights!

  Points: 810

  More actions

  February 27, 2014 at 7:21 am

  #284020

  I have a developer who is dbo of a database he is working on but does not have permission to run the profiler tool. any thoughts ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 27, 2014 at 7:25 am

  #1692683

  DBO does not include trace permissions. You need to explicitly grant him the ALTER TRACE permission at the server level.

  GRANT ALTER TRACE TO <login name>

  The only fixed role which includes the ALTER TRACE permission is sysadmin.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• crmitchell

  SSCarpal Tunnel

  Points: 4557

  More actions

  February 28, 2014 at 7:35 am

  #1693069

  For a good visualisation of server and database roles try here

  http://social.technet.microsoft.com/wiki/contents/articles/2024.database-engine-fixed-server-and-fixed-database-roles.aspx