SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Dynamic Table Creation Auditing

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Dynamic Table Creation Auditing
Author Message
Jeff Wilson



Joined: 14 Jul 2009
Posts: 1
Country: Canada

Post Dynamic Table Creation Auditing Reply with quote
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
Tue Jul 14, 2009 5:30 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6507

Post Reply with quote
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.
Tue Jul 14, 2009 5:38 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.