Auditing Oracle DML
Is there anyone using Oracle that uses some sort of software to audit DML statements? If so what might you be using? Something rather than Logminer? Is there something out there that would track and record all select,delete,insert, and update statements for Oracle? I know I could use triggers but I need something more user friendly for a non-technical internal auditor to be able to track changes to the database. This seems to be a concern to many I have talked to and we are in desperate need of finding something to accomodate this.
You run the logminer- create a report and give it to your 'Non technical auditor'
That would be way simple....when it is freely available.
You can create tirggres on each table for the event insert,update,delete. These information u can store in History table and u can use that history table for report generation in front end. We are using the same technique in our office and its quite helpfull.