Oracle SQL: the Essential Reference

AUDIT (SQL Statements)

AUDIT {system_option | sql_option}[,{system_option | sql_option ...}] {[BY username[,username ...]] | [BY PROXY [ON BEHALF OF {ANY|username[,username]]} } {[BY SESSION] [WHENEVER [NOT] SUCCESSFUL] | [BY ACCESS] [WHENEVER [NOT] SUCCESSFUL] }

Sets up auditing for specific SQL statements in subsequent user sessions.

Keywords

system_option

Specifies that SQL statements authorized by the named system privilege be audited.

sql_option

Specifies a set of SQL statements to be audited.

BY username

Specifies that SQL statements issued by the named user be audited.

BY proxy

Specifies that SQL statements issued by the specified proxy be audited.

ON BEHALF OF ANY

Specifies that SQL statements issued on behalf of any user be audited.

ON BEHALF OF user

Specifies the user on whose behalf the proxy executes the specified statement.

BY SESSION

Causes Oracle to write a single record for all SQL statements of the same type issued in the same session.

BY ACCESS

Causes Oracle to write a single record for each audited statement.

WHENEVER SUCCESSFUL

Chooses auditing only for SQL statements that complete successfully.

WHENEVER NOT SUCCESSFUL

Chooses auditing only for SQL statements that fail or result in errors.

Audit records are written to the audit trail, which is a database table containing audit records that can be accessed through data dictionary views. Auditing must be enabled ...