Name

NOAUDIT (SQL Statements)

Synopsis

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.

Keywords

statement_opt

Statement option for which auditing will be stopped. See Chapter 4 for details.

system_priv

System privilege for which auditing will be stopped. See Chapter 4 for details.

BY username

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

BY proxy

Stops auditing only for SQL statements issued by proxy on behalf of a user or a list of specific users.

WHENEVER SUCCESSFUL

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.

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.

Start your free trial