NOAUDIT Statement

Stop auditing an SQL statement or accesss to a specific database object.

Syntax:

Privileges

   NOAUDIT {ALL|ALL PRIVILEGES|sql_statement|system_priv} [options]
      [WHENEVER [NOT] SUCCESSFUL]
	  
      options:
            BY user
            BY proxy [ON BEHALF OF ANY|user]
			
Schema Objects

   NOAUDIT {ALL|action} on [schema.]object
      [WHENEVER [NOT] SUCCESSFUL]

   NOAUDIT {ALL|action} on DIRECTORY directory_name
      [WHENEVER [NOT] SUCCESSFUL]

   NOAUDIT {ALL|action} on DEFAULT
      [WHENEVER [NOT] SUCCESSFUL]

actions:
   ALTER, AUDIT, COMMENT, DELETE, EXECUTE, GRANT,
   INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE

You can disable all auditing with the init.ora parameter AUDIT_TRAIL = NO

"Happiness is good health and a bad memory" - Ingrid Bergman

Related Commands:

AUDIT
GRANT

Related Views:

 DBA_AUDIT_EXISTS
 DBA_AUDIT_OBJECT           USER_AUDIT_OBJECT
 DBA_AUDIT_SESSION          USER_AUDIT_SESSION
 DBA_AUDIT_STATEMENT        USER_AUDIT_STATEMENT
 DBA_AUDIT_TRAIL            USER_AUDIT_TRAIL

Equivalent SQL Server command:

DBCC TRACEOFF