I want to thank the selection committee for having the opportunity to present at SQL Saturday #235 in New York City.
There is an all-star line up of speakers this day. It should be a good time to network with other professionals in the field and learn some new things about the product.
I will definitely be listing to Lovin Spoonful’s “Summer In The City” on the drive down. I learnt from last year to wear shorts since it is hot in the city!
Below are the details of the presentation. I hope you have time to attend cool event on August 17th, 2013.
How to audit and prevent unwanted user actions.
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.