Post reply

2012 new database & login auditing

  • August 3, 2022 at 12:21 pm

    #4071883

    Morning all,

    SQL 2012 Ent.  I want a job to run that will alert me to the creation of new dbs, logins, and certain permission changes to logins.  I can write my own checker & schedule but I'm wondering if you good people have a better way!

    If not thank you.

    🙂

  • August 4, 2022 at 1:10 pm

    #4072460

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • August 12, 2022 at 8:34 am

    #4075509

    Hello snomadj.

    Take a look at SQLVER.

    https://github.com/DavidRueter/SQLVer/blob/master/README.md

    It's not fully auto, but changes are logged in tables and you can easily setup a job to email you the changes. Or a trigger to alert you when a new record is inserted in the SQLVER tables.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply