DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003

    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.

  2. #2
    Join Date
    Jan 2001

    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.

    There is always a better way to do the things.

  3. #3
    Join Date
    May 2003
    Bangalore , India
    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.
    Mohit Sharan
    Cell No : 91-9845211820

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.