Account logging - pwd change/db access change

• Warren Peace

  SSCertifiable

  Points: 5881

  More actions

  May 27, 2022 at 2:42 am

  #4039992

  Is there a way to continuously log account changes?

  For SQL accounts log for who and when the pwd changes and mappings to db's change as well as role changes?

   

  For domain groups or accounts, log for who and when the mappings to db's change as well as role changes?

   

  Thanks

• ratbak

  Default port

  Points: 1418

  More actions

  May 27, 2022 at 1:30 pm

  #4040226

  DDL Trigger

• Johan Bijnens

  SSC Guru

  Points: 135536

  More actions

  May 30, 2022 at 11:24 am

  #4041506

  Extended events are your friends !

  e.g. "Audit Login Change Password Event Class"

  You can always start reading my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me