May 27, 2022 at 2:42 am
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
May 27, 2022 at 1:30 pm
DDL Trigger
May 29, 2022 at 11:46 am
This was removed by the editor as SPAM
May 30, 2022 at 11:24 am
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
June 1, 2022 at 6:25 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply