Profiler for sysasmins only?

• Natalia Mirochnick

  SSC Enthusiast

  Points: 178

  More actions

  May 13, 2002 at 2:56 am

  #101146

  Hello, SQL Gurus!

  Can non-sysadmins users of SQL Server 2000 profile it? I gave them permissions for appropriate procedures but it doesn't works.

  Thanks in advance!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 13, 2002 at 4:49 am

  #428994

  Every process and sp need to create and run traces can only be Executed by the sysadmin fixed role. As stated here by DBCC TRACEON

  quote:

  ---

  DBCC TRACEON permissions default to members of the sysadmin fixed server role only, and are not transferable.

  ---

  and sp_trace_create

  quote:

  ---

  Only members of the sysadmin fixed server role can execute sp_trace_create.

  ---

  so non-sysadmin users are barred from using Profiler.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  Edited by - antares686 on 05/13/2002 04:49:40 AM