This discussion is archived
1 Reply Latest reply: May 28, 2012 6:21 AM by KuljeetPalSingh RSS

Statement AUDIT SELECT TABLE also audits update, delete and inserts

Erik Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points