AUDIT (Schema Objects)
AUDITobject_privilege
[,object_privilege
...] ON {[schema
.]object_name
| DEFAULT} [BY SESSION [WHENEVER [NOT] SUCCESSFUL] [BY ACCESS [WHENEVER [NOT] SUCCESSFUL]
Sets up auditing for a specific schema object (object_name).
Indicates that a particular operation is to be audited. The following are valid operations: ALTER, AUDIT, COMMENT, DELETE, EXECUTE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The keyword ALL is equivalent to specifying all of the operations listed.
Establishes the specified object options as the default for objects that have not yet been created.
Causes Oracle to write a single record for all SQL statements of the same type issued in the same session.
Causes Oracle to write a single record for each audited statement.
Chooses auditing only for SQL statements that complete successfully.
Chooses auditing only for SQL statements that fail or result in errors.
You must own the object to be audited or have the AUDIT SYSTEM privilege to issue this command. Audit records are written to the audit trail, a database table containing audit records that can be accessed through data dictionary views. Note that auditing must be enabled using the INIT.ORA parameter AUDIT_TRAIL.