AUDIT SELECT, INSERT, UPDATE, DELETE ON HR.P_LISTA;
COMMIT;
AUDIT SELECT, INSERT, UPDATE, DELETE ON HR.P_LISTA BY ACCESS;
NOAUDIT SELECT, INSERT, UPDATE, DELETE ON HR.P_LISTA;
AUDIT INSERT, UPDATE, DELETE ON HR.P_LISTA BY ACCESS;
The user TSUTTON had auditing set up BY SESSION and we see that the ACTION_NAME appears as ‘SESSION REC’ in each case, which shows that auditing is being done at the session level. The user BWILLIAMS had auditing set at the access level, and here we see a listing of every insert and delete, along with the timestamp of the action, even though several inserts were performed on the same table in the same session.
Źródła:
http://www.dbspecialists.com/december-2003.html
http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/audit.htm