Permissions for running Trace

• sandhyarao49

  SSCrazy

  Points: 2215

  More actions

  April 20, 2010 at 7:07 pm

  #221556

  Hello,

  In order to run the profiler on a server one requires Admin permissions.

  Can anyone let me know how to give profiler permission to a particular user without admin privileges?

  Regards,

  Sandhya

• WayneS

  SSC Guru

  Points: 95461

  More actions

  April 20, 2010 at 8:44 pm

  #1155060

  You don't need to give admin permissions, all you need to do is to grant alter trace permissions. See this entry in BOL for how to do this.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  April 21, 2010 at 1:42 am

  #1155152

  Hi,

  You can give permissions to another logins(Not admins) to trace through SQL Profiler.

  Go To that login, select properties. and then go to securables

  there you can add Here.

  Here you will find three types. you can add server here.

  and then you will give grant permission for alter trace row.

  and then click ok.

  profiler allow that login to run trace.

  all d best

  Regards

  GaNeSH

  GaNeSH