User to run trace but not to access database.

• Saravanan T

  SSCrazy

  Points: 2506

  More actions

  May 11, 2010 at 2:05 am

  #386901

  Hi ,

  How to create a user to run a trace but not to access a database.

  Regards,

  Saravanan T

  Regards,
  Saravanan

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  May 13, 2010 at 3:58 am

  #1166743

  USE master;

  GRANT ALTER TRACE TO LoginID;

  GO

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)