Oracle PL/SQL/User Previliege/AUDIT

Turning Auditing Off

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

Turning Auditing On in the Database

 

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;

--