|Subject:||questions on audit question|
|Date:||21 Jan 2005|
I want to audit any insert, update transaction on a particular table.
So I set audit_trail=DB then "audit insert, update on db1.tablename;"
>From the SYS.AUD$ table, the result only shows ONE audit record for
each session. For example, if UserA do 2 INSERTS and 3 UPDATES on the
table during the session, I only got ONE record in SYS.AUD$:
SQL> select userid, ses$actions from user_audit_object;
But I want to see the exact number of times the tables are being insert
and update. How to accomplish that?