Dynamic Table Creation Auditing

Hello,
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?

Thanks
Jeff

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.