December 2002
Intermediate to advanced
928 pages
85h 29m
English
NOAUDIT (SQL Statements)
NOAUDIT {statement_opt | system_priv}[,{statement_opt | system_priv} ...] [BY
{ username[,username ...]
| proxy [ON BEHALF OF
{ANY
| username [,username ...]
}]
}]
[WHENEVER [NOT] SUCCESSFUL]Stops auditing defined by a prior AUDIT statement for SQL statements.
Statement option for which auditing will be stopped. See Chapter 4 for details.
System privilege for which auditing will be stopped. See Chapter 4 for details.
Stops auditing only for SQL statements issued by a username in this list. The default option is to stop auditing for all users.
Stops auditing only for SQL statements issued by proxy on behalf of a user or a list of specific users.
Stops auditing only for SQL statements that complete successfully. If NOT is specified, auditing stops only for SQL statements that result in an error. If this clause is omitted, auditing stops for all SQL statements, successful or not.