Name
NOAUDIT (Schema Objects)
Synopsis
NOAUDITobject_option[,object_option...] ON {[schema.]object_name| DIRECTORYdirectory_name| DEFAULT} [WHENEVER [NOT] SUCCESSFUL]
Stops auditing defined by a prior AUDIT statement for schema objects.
Keywords
- object_option
Indicates that auditing on a particular operation will be stopped. The following operations are valid: ALTER, AUDIT, COMMENT, DELETE, EXECUTE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, and UPDATE. The keyword ALL is equivalent to specifying all of the operations.
- object_name
Name of the schema object for which auditing will be stopped.
- DIRECTORY
Specifies the name of a directory for which auditing will be stopped.
- DEFAULT
Specifies that no auditing will be performed as the default for objects that have not yet been created for the specified object option.
- WHENEVER SUCCESSFUL
Turns off auditing only for SQL statements that complete successfully.
- WHENEVER NOT SUCCESSFUL
Turns off auditing only for SQL statements that fail or result in errors.
Common keywords and clauses: schema.