NOAUDIT sql_statements

Syntax

Purpose

To stop auditing previously enabled by the AUDIT sql_statements statement. To stop auditing enabled by the AUDIT schema_objects statement, refer to "NOAUDIT schema_objects".

The NOAUDIT statement must have the same syntax as the previous AUDIT statement. Further, it reverses the effects only of that particular statement. Therefore, if one AUDIT statement (statement A) enables auditing for a specific user, and a second (statement B) enables auditing for all users, then a NOAUDIT statement to disable auditing for all users (statement C) reverses statement B, but leaves statement A in effect and continues to audit the user that statement A specified. For information on auditing specific SQL statements, see the "AUDIT sql_statements".

Prerequisites

You must have the AUDIT SYSTEM system privilege.

Keywords and Parameters

statement_opt	is a statement option for which auditing is stopped. For a list of the statement options and the SQL statements they audit, see Table 7-1 and Table 7-2.
system_priv	is a system privilege for which auditing is stopped. For a list of the system privileges and the statements they authorize, see Table 7-5.
BY user	stops auditing only for SQL statements issued by specified users in their subsequent sessions. If you omit this clause, Oracle stops auditing for all users' statements, except for the situation described for WHENEVER SUCCESSFUL.
BY proxy	stops auditing only for the SQL statements issued by the specified proxy, on behalf of a specific user or any user.
WHENEVER SUCCESSFUL	stops auditing only for SQL statements that complete successfully. NOT stops auditing only for statements that result in Oracle errors.
	If you omit the WHENEVER SUCCESSFUL clause entirely, Oracle stops auditing for all statements, regardless of success or failure.

Examples

The following examples correspond to three examples listed in "AUDIT sql_statements".

If you have chosen auditing for every SQL statement that creates or drops a role, you can stop auditing of such statements by issuing the following statement:

NOAUDIT ROLE; 

If you have chosen auditing for any statement that queries or updates any table issued by the users SCOTT and BLAKE, you can stop auditing for SCOTT's queries by issuing the following statement:

NOAUDIT SELECT TABLE 
   BY scott; 

The above statement stops auditing only SCOTT's queries, so Oracle continues to audit BLAKE's queries and updates as well as SCOTT's updates.

To stop auditing on all statements that are authorized by DELETE ANY TABLE system privilege, issue the following statement:

NOAUDIT DELETE ANY TABLE;