AUDIT Statement

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

Syntax:

   NOAUDIT {ALL|ALL PRIVILEGES|sql_statement|system_priv} [options]
      [WHENEVER [NOT] SUCCESSFUL]

options:
      BY user
      BY proxy [ON BEHALF OF ANY|user]

Schema Objects
   To noaudit an object use the modified syntax

   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  




Back to the Top

Simon Sheppard
SS64.com