Saturday, February 25, 2012

Audit

I want to register into a table each time a user creates, modifies or deletes any object in a database. It's not possible to add a trigger to the sysobjects table. What can I do?SQL 2005 will have that feature...the best I can tell you is to not allow them DDL Priviliges, and have them run all the DDL request through you...

No comments:

Post a Comment