July 18, 2007 at 4:34 pm
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?
July 19, 2007 at 5:51 am
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.
July 19, 2007 at 7:34 am
Nope. I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.
July 19, 2007 at 7:34 am
Nope. I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.
July 19, 2007 at 7:42 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply