Auditing
Databases
A typical requirement in Enterprise Database Applications is to know who, when
and how certain table record was modified. Most DBMS's don't have intrinsic simple
capabilities for auditing table records in a transparent way and present
auditing results to
end-users. That's the motivation for developing Auditing Tools.
There are 2 big auditing techniques:
-
Extract audit information from the database transaction log.
-
Audit data changes through database triggers.
Both techniques are valid and work fine. Our auditing tool takes the second
approach, generating database triggers code to audit data changes in table
rows.
Our Solution
We have developed a WEB trigger generation tool that takes a a table creation
script as entry and then generates database audit triggers.
Right now the tool generates triggers for Microsoft SQL Server only. In future versions the tool will also generate triggers for most of the common DBMS's (Oracle, MySQL, DB2, PostGreSQL, etc.)
Here you can learn more about this tool. Try it, it's free!
|