Turning Auditing On in the Database : AUDIT « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. AUDIT

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;



--

 

Related examples in the same category