Mega Code Archive

 
Categories / Oracle PLSQL / User Previliege
 

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; --