Oracle PL/SQL/User Previliege/AUDIT

Turning Auditing Off

   <source lang="sql">

NOAUDIT SESSION; NOAUDIT DELETE ANY TABLE BY userName WHENEVER NOT SUCCESSFUL; NOAUDIT DELETE ANY TABLE BY userName;

</source>
   
  

Turning Auditing On in the Database

   <source lang="sql">

AUDIT SELECT ON employees; AUDIT DELETE ANY TABLE BY userName WHENEVER NOT SUCCESSFUL; AUDIT UPDATE ANY TABLE; AUDIT SESSION BY UserName; AUDIT SELECT,INSERT,UPDATE,DELETE ON employees BY ACCESS WHENEVER SUCCESSFUL;

--

</source>