Notify Admin on MasterKey backup

  • Is there a way to create a notification when ever a user opens a symmetric Key attempt to backup the Database Master Key from the database?

  • I haven't tried this, but you might investigate setting up a DDL trigger on the certification events.  Or check the other DDL Events and Event Groups to see if something might help you out.

     

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Nope.  I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.

  • Nope.  I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.

  • The backup for the Master Key requires a CONTROL permission on the database.  That tells me the person has to be a SysAdmin, DBOwner or a DBBackupOperator.  I don't know of any way to send messages on the actions of people with a particular role or permission set.  However, you can log this sort of thing. 

    Creating custom logging might be your best bet.  Though Profiler is a good tool to use if you think this is going to happen during a certain time frame.  The only problem with Profiler is if you make the trace too large, it'll ding your server performance.  Profiler can also tell you exactly who is doing what in your database.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 5 posts - 1 through 4 (of 4 total)

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