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.
|
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.