ORACLE NOAUDIT命令

桃扇骨 2023-10-19 07:58 81阅读 0赞

## NOAUDIT ##

Purpose

Use the `NOAUDIT` statement to stop auditing operations previously enabled by the `AUDIT` statement.

The `NOAUDIT` statement must have the same syntax as the previous `AUDIT` statement. Further, it reverses the effects only of that particular statement. For example, suppose one `AUDIT` statement A enables auditing for a specific user. A second statement B enables auditing for all users. A `NOAUDIT` statement C to disable auditing for all users reverses statement B. However, statement C leaves statement A in effect and continues to audit the user that statement A specified.

See Also:

[AUDIT][] for more information on auditing

Prerequisites

To stop auditing of SQL statements, you must have the `AUDIT` `SYSTEM` system privilege.

To stop auditing of schema objects, you must be the owner of the object on which you stop auditing or you must have the `AUDIT` `ANY` system privilege. In addition, if the object you chose for auditing is a directory, then even if you created it, you must have the `AUDIT` `ANY` system privilege.

Syntax

noaudit::=

![Description of noaudit.gif follows][]  
[Description of the illustration noaudit.gif][]

([sql\_statement\_clause ::=][sql_statement_clause], [schema\_object\_clause ::=][schema_object_clause])

[sql\_statement\_clause][sql_statement_clause 1] ::=

![Description of sql\_statement\_clause.gif follows][Description of sql_statement_clause.gif follows]  
[Description of the illustration sql\_statement\_clause.gif][Description of the illustration sql_statement_clause.gif]

auditing\_by\_clause::=

![Description of auditing\_by\_clause.gif follows][Description of auditing_by_clause.gif follows]  
[Description of the illustration auditing\_by\_clause.gif][Description of the illustration auditing_by_clause.gif]

[schema\_object\_clause][schema_object_clause 1] ::=

![Description of schema\_object\_clause.gif follows][Description of schema_object_clause.gif follows]  
[Description of the illustration schema\_object\_clause.gif][Description of the illustration schema_object_clause.gif]

auditing\_on\_clause::=

![Description of auditing\_on\_clause.gif follows][Description of auditing_on_clause.gif follows]  
[Description of the illustration auditing\_on\_clause.gif][Description of the illustration auditing_on_clause.gif]

Semantics

sql\_statement\_clause

Use the `sql_statement_clause` to stop auditing of a particular SQL statement.

statement\_option For `statement_option`, specify the statement option for which auditing is to be stopped. Please refer to [Table 13-1][] and [Table 13-2][] for a list of the statement options and the SQL statements they audit.

ALL Specify `ALL` to stop auditing of all statement options currently being audited.

system\_privilege For `system_privilege`, specify the system privilege for which auditing is to be stopped. Please refer to [Table 18-1][] for a list of the system privileges and the statements they authorize.

ALL PRIVILEGES Specify `ALL` `PRIVILEGES` to stop auditing of all system privileges currently being audited.

auditing\_by\_clause Use the `auditing_by_clause` to stop auditing only those SQL statements issued by particular users. If you omit this clause, then Oracle Database stops auditing all users' statements.

*  Specify `BY` `user` to stop auditing only for SQL statements issued by the specified users in their subsequent sessions. If you omit this clause, then Oracle Database stops auditing for all users' statements, except for the situation described for `WHENEVER` `SUCCESSFUL`.
 *  Specify `BY` `proxy` to stop auditing only for the SQL statements issued by the specified proxy, on behalf of a specific user or any user.

schema\_object\_clause

Use the `schema_object_clause` to stop auditing of a particular database object.

object\_option For `object_option`, specify the type of operation for which auditing is to be stopped on the object specified in the `ON` clause. Please refer to [Table 13-3][]for a list of these options.

ALL Specify `ALL` as a shortcut equivalent to specifying all object options applicable for the type of object.

auditing\_on\_clause  The `auditing_on_clause` lets you specify the particular schema object for which auditing is to be stopped.

*  For object, specify the object name of a table, view, sequence, stored procedure, function, or package, materialized view, or library. If you do not qualify `object` with `schema`, then Oracle Database assumes the object is in your own schema. Please refer to [AUDIT][] for information on auditing specific schema objects.
 *  The `DIRECTORY` clause lets you specify the name of the directory on which auditing is to be stopped.
 *  Specify `DEFAULT` to remove the specified object options as default object options for subsequently created objects.

NETWORK Use this clause to discontinue auditing of database link usage and logins.

WHENEVER \[NOT\] SUCCESSFUL ``Specify `WHENEVER` `SUCCESSFUL` to stop auditing only for SQL statements and operations on schema objects that complete successfully.

Specify `WHENEVER` `NOT` `SUCCESSFUL` to stop auditing only for statements and operations that result in Oracle Database errors.

If you omit this clause, then the database stops auditing for all statements or operations, regardless of success or failure.

Examples

Stop Auditing of SQL Statements Related to Roles: Example If you have chosen auditing for every SQL statement that creates or drops a role, then you can stop auditing of such statements by issuing the following statement:

NOAUDIT ROLE;

Stop Auditing of Updates or Queries on Objects Owned by a Particular User: Example If you have chosen auditing for any statement that queries or updates any table issued by the users `hr` and `oe`, then you can stop auditing for queries by `hr` by issuing the following statement:

NOAUDIT SELECT TABLE BY hr;

The preceding statement stops auditing only queries by `hr`, so the database continues to audit queries and updates by `oe` as well as updates by `hr`.

Stop Auditing of Statements Authorized by a Particular Object Privilege: Example To stop auditing on all statements that are authorized by `DELETE` `ANY` `TABLE` system privilege, issue the following statement:

NOAUDIT DELETE ANY TABLE;

Stop Auditing of Queries on a Particular Object: Example If you have chosen auditing for every SQL statement that queries the `employees` table in the schema `hr`, then you can stop auditing for such queries by issuing the following statement:

NOAUDIT SELECT 
       ON hr.employees;

Stop Auditing of Queries that Complete Successfully: Example You can stop auditing for queries that complete successfully by issuing the following statement:

NOAUDIT SELECT 
       ON hr.employees
       WHENEVER SUCCESSFUL;

This statement stops auditing only for successful queries. Oracle Database continues to audit queries resulting in Oracle Database errors.

[AUDIT]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#i2059073
[Description of noaudit.gif follows]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9kb2NzLm9yYWNsZS5jb20vY2QvQjE5MzA2XzAxL3NlcnZlci4xMDIvYjE0MjAwL2ltZy9ub2F1ZGl0LmdpZg
[Description of the illustration noaudit.gif]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/noaudit.htm
[sql_statement_clause]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9017.htm#i2123640
[schema_object_clause]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9017.htm#i2123651
[sql_statement_clause 1]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9017.htm#i2064568
[Description of sql_statement_clause.gif follows]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9kb2NzLm9yYWNsZS5jb20vY2QvQjE5MzA2XzAxL3NlcnZlci4xMDIvYjE0MjAwL2ltZy9zcWxfc3RhdGVtZW50X2NsYXVzZS5naWY
[Description of the illustration sql_statement_clause.gif]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/sql_statement_clause.htm
[Description of auditing_by_clause.gif follows]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9kb2NzLm9yYWNsZS5jb20vY2QvQjE5MzA2XzAxL3NlcnZlci4xMDIvYjE0MjAwL2ltZy9hdWRpdGluZ19ieV9jbGF1c2UuZ2lm
[Description of the illustration auditing_by_clause.gif]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/auditing_by_clause.htm
[schema_object_clause 1]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9017.htm#i2128547
[Description of schema_object_clause.gif follows]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9kb2NzLm9yYWNsZS5jb20vY2QvQjE5MzA2XzAxL3NlcnZlci4xMDIvYjE0MjAwL2ltZy9zY2hlbWFfb2JqZWN0X2NsYXVzZS5naWY
[Description of the illustration schema_object_clause.gif]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/schema_object_clause.htm
[Description of auditing_on_clause.gif follows]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9kb2NzLm9yYWNsZS5jb20vY2QvQjE5MzA2XzAxL3NlcnZlci4xMDIvYjE0MjAwL2ltZy9hdWRpdGluZ19vbl9jbGF1c2UuZ2lm
[Description of the illustration auditing_on_clause.gif]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/img_text/auditing_on_clause.htm
[Table 13-1]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#BABEFEAC
[Table 13-2]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#g2274817
[Table 18-1]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm#BABEFFEE
[Table 13-3]: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4007.htm#g2275496