Auditing Oracle DML
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Auditing Oracle DML

Hybrid View

  1. #1
    Join Date
    Feb 2003
    Posts
    19

    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
    Posts
    642
    Hey!!

    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.

    Badrinath
    There is always a better way to do the things.

  3. #3
    Join Date
    May 2003
    Location
    Bangalore , India
    Posts
    31
    Hi,
    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
    DBA
    Bangalore.
    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