Name
AUDIT (Schema Objects)
Synopsis
AUDIT {object_option[,object_option
...] | ALL}
ON {[schema.]object_name | DIRECTORY directory_name | DEFAULT}
[BY SESSION [WHENEVER [NOT] SUCCESSFUL]
[BY ACCESS [WHENEVER [NOT] SUCCESSFUL]
Sets up auditing for a specific schema object.
Keywords
- object_option
Indicates that a particular operation will be audited. The following operations are valid: ALTER, AUDIT, COMMENT, DELETE, EXECUTE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The keyword ALL specifies all of these operations.
- object_name
Name of the schema object to be audited.
- DIRECTORY directory_name
Specifies the name of a directory to audit.
- DEFAULT
Establishes the specified object option as the default for objects that have not yet been created.
- 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.
Common keywords and clauses: schema.
Get Oracle in a Nutshell 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.