Sunday, December 13, 2009

Audit all Oracle user activity.

Audit all Oracle user activity.
This audits everything including DDL (create table), DML (inserts, updates, deletes) and login/logoff events:
audit all by FRED by access;
Audit all Oracle user viewing activity:
audit select table by FRED by access;
Audit all Oracle user data change activity:
audit update table, delete table,
insert table by FRED by access;
Audit all Oracle user viewing activity:
audit execute procedure by FRED by access;
We can also query the dba_audit_trail view. Here are the column descriptions from the Oracle documentation:

1 comment:

  1. nice tool. However, I have heard about another program for how do you import information into a sql database, check it out and find out why it is more efficient

    ReplyDelete