Oracle7 Server SQL Reference
NOAUDIT (SQL Statements)
Purpose
To stop auditing chosen by the AUDIT command (SQL Statements). To stop auditing chosen by the AUDIT command (Schema Objects), use the NOAUDIT command (Schema Objects) described in the next section of this chapter.
Prerequisites
You must have AUDIT SYSTEM system privilege.
If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the label at which the auditing option was set or you must satisfy one of the following criteria:
- If the auditing option was set at a label higher than your DBMS label, you must have READUP and WRITEUP system privileges.
- If the auditing option was set at a label lower than your DBMS label, you must have WRITEDOWN system privilege.
- If the auditing option was set at a label not comparable to your DBMS label, you must have READUP, WRITEUP, and WRITEDOWN system privileges.
Syntax
![](image124.gif)
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 4 - 7 and Table 4 - 8.
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 4 - 7.
BY
stops auditing only for SQL statements issued by specified users in their subsequent sessions. If you omit this clause, Oracle7 stops auditing for all users' statements, except for the situation described in the section that follows.
WHENEVER SUCCESSFUL
stops auditing only for SQL statements that complete successfully.
NOT
stops auditing only for statements that result in Oracle7 errors.
If you omit the WHENEVER clause entirely, Oracle7 stops auditing for all statements, regardless of success or failure.
Usage Notes
A NOAUDIT statement (SQL Statements) reverses the effect of a previous AUDIT statement (SQL Statements). Note that the NOAUDIT statement must have the same syntax as the previous AUDIT statement and that it only reverses the effects 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 commands, see the AUDIT command (SQL Statements) command
.
Example I
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
Example II
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
Since the above statement only stops auditing SCOTT's queries, Oracle7 continues to audit BLAKE's queries and updates and SCOTT's updates.
Example III
To stop auditing on all statements that are authorized by DELETE ANY TABLE system privileges chosen for auditing, issue the following statement:
NOAUDIT ALL
Related Topics
AUDIT (SQL Statements) command
NOAUDIT (Schema Objects) command ![[*]](jump.gif)