NOAUDIT
NOAUDIT {statement_opt
|system_priv
}[,{statement_opt
|system_priv
...} [BYusername
[,username
...] [WHENEVER [NOT] SUCCESSFUL]
Stops auditing defined by a prior AUDIT statement.
Specifies a statement option for which auditing is to be stopped.
Specifies a system privilege for which auditing is to be stopped.
Stops auditing only for SQL statements issued by a username in this list. The default is all users.
Stops auditing only for SQL statements that complete successfully. If NOT is specified, auditing is stopped only for SQL statements that result in an error. If this clause is omitted, auditing is stopped for all SQL statements, successful or not.