Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008

    Unanswered: Auditing Single Table

    Please someone let me know how I can Audit one single table within Oracle database. I am using Oracle 9i R2 Database.


  2. #2
    Join Date
    Sep 2002
    Make sure auditing is enabled by setting the initialization parameter AUDIT_TRAIL. Changing this parameter requires bouncing the database.

    To audit activities on a specific object, use a command similar to "AUDIT ALL ON <object_name> BY ACCESS". the "ALL" option can be replaced by specific actions if you only want to audit a subset of those actions. For instance, auditing select activity on a heavily used table will generate lot's of audit trail data. This may impact performance.

    Here is a link to the docs:

Posting Permissions

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