Skip to content
≡

Administrator

Developer

Tools

External Tools

NOAUDIT

NOAUDIT#

Syntax#

noaudit ::=#

noaudit

audit_operation_clause ::=#

noaudit_operation_clause

by_clause ::=#

noaudit_by_clause

audit_object_clause ::=#

noaudit_object_clause

ddl_clause ::=#

audit_ddl_clause

Prerequisites#

Only the SYS user can disable auditing conditions with this statement.

Description#

The NOAUDIT statement is used to disable auditing conditions that were previously enabled with the AUDIT statement.

audit_operation_clause#

This clause is used to stop the auditing of certain SQL statements.

sql_statement_type specifies auditing of the specified operation to be stopped. For further information on auditing operations available for specification, please refer to the description section of the AUDIT statement.

ALL is used to stop auditing of all statements previously specified with the AUDIT ALL statement.

audit_object_clause#

This clause is used to disable the auditing condition of a certain object.

For sql_operation, specify the type of operation for which auditing is to be stopped on the object specified in the ON clause. For further information on SQL operations available for specification, please refer to the Description section of the AUDIT statement.

ALL is equivalent to specifying all SQL statements executable of an object type.

ddl_clause#

This clause specifies auditing of DDL statements to stop.

WHENEVER [NOT] SUCCESSFUL#

WHENEVER SUCCESSFUL specifies auditing of successful SQL statements and object operations to stop.

WHENEVER NOT SUCCESSFUL specifies auditing of unsuccessful SQL statements and object operations to stop.

On omission, auditing of specified statements and object operations are stopped, regardless of its success or failure.

Precautions#

Even if an auditing condition is disabled with the NOAUDIT statement, this is not immediately applied to database auditing. For the disablement of an auditing condition to be applied to the running server, auditing must be restarted or RELOAD must be performed for the auditing conditions with the following statements.

ALTER SYSTEM STOP AUDIT;
ALTER SYSTEM START AUDIT;
ALTER SYSTEM RELOAD AUDIT;

Examples#

<Query 1> Disable auditing of successful SELECT statements on the table friends.

iSQL> NOAUDIT select ON friends WHENEVER SUCCESSFUL;
Audit success.

<Query 2> Disable auditing of SELECT statements.

iSQL> NOAUDIT select;
Audit success.

<Query 3> Disable auditing of DDL statements.

iSQL> NOAUDIT DDL;
Audit success.