Database Trigger - Tracking Role changes

• JJ van der Walt

  SSC Rookie

  Points: 47

  More actions

  May 31, 2007 at 2:05 am

  #178856

  I am looking at tracking changes to users and their access with database and server triggers. It works well accept for changes to roles (sp_addrolemember and sp_droprolemember)

  Database triggers can not handle ADD_ROLE_MEMBER and DROP_ROLE_MEMBER events.

  How can I track changes to roles with these two events?

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  June 1, 2007 at 9:55 am

  #710378

  You'll have to use Event Notifications or a constantly running profiler trace.

  Greg

  Greg