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>