Name

NOAUDIT

Synopsis

NOAUDIT {statement_opt |
system_priv}[,{statement_opt
| system_priv ...}
[BY
username[,username
...]
   [WHENEVER [NOT] SUCCESSFUL]

Stops auditing defined by a prior AUDIT statement.

Keywords

statement_opt

Specifies a statement option for which auditing is to be stopped.

system_priv

Specifies a system privilege for which auditing is to be stopped.

BY username

Stops auditing only for SQL statements issued by a username in this list. The default is all users.

WHENEVER SUCCESSFUL

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.

Note

You must have the AUDIT ANY privilege to issue this command.

Example

The following example stops auditing of INSERT and DELETE statements issued by scott on the emp table:

NOAUDIT INSERT,DELETE ON scott.emp
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset