AUDIT (SQL Statements)
AUDIT {system_privilege
|sql_statement
}[,{system_privilege
|sql_statement
...}] [BYuser
[,user
...]] [BY SESSION [WHENEVER [NOT] SUCCESSFUL] [BY ACCESS [WHENEVER [NOT] SUCCESSFUL]
Sets up auditing for specific SQL statements in subsequent user sessions.
Indicates that the SQL statement authorized by the named system privilege is to be audited.
Indicates that a set of SQL statements (e.g., SELECT, UPDATE) specified by the system option is to be audited.
Indicates that SQL statements issued by the particular user are to be audited.
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.