1 Reply Latest reply: May 28, 2012 8:21 AM by kuljeet singh - RSS

    Statement AUDIT SELECT TABLE also audits update, delete and inserts

    Erik
      Hi,

      Database Oracle 11g.

      After turning on AUDIT with these 2 statements:

      SQL> ALTER SYSTEM SET audit_trail = "DB_EXTENDED" SCOPE=SPFILE;
      SQL> AUDIT SELECT TABLE BY ACCESS;

      then insert, update and delete statements are recorded in sys.aud$ as well as select statements.

      My expectation was to see only select statements in sys.aud$.

      Please clarify :-)

      Best regards
      Erik