I am in need of an application that can provide data change auditing on tables that are created dynamically with unique table names. Is this possible with DB Audit?
Tue Jul 14, 2009 5:30 pm
SysOp Site Admin
Joined: 26 Nov 2006 Posts: 4612
This is doable using DB Audit API. Basically, the idea here is to monitor database for CREATE TABLE events, you can use some custom method or use DB Audit Alert Center server for that, and then attach a process that will call DB Audit and dynamically deploy auditing for new tables.
One deficiency of this method is that there is going to be a relatively small time gap (10-15 minutes or less) between table creation and audit setting deployment for new tables. To eliminate this gap, check if you can attach deployment step directly to the process that creates tables in the database.
You can also use the system-auditing to monitor activities at the SQL level and capture all DLL operations for all tables and then filter results for new tables only. But this would provide you with SQL queries, not the data updated/deleted/inserted into these tables.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum