Introduction to Simple Oracle Auditing | Symantec Connect

implemented for PCI

AUDIT CREATE SESSION BY ACCESS WHENEVER SUCCESSFUL;
AUDIT CREATE SESSION BY ACCESS WHENEVER NOT SUCCESSFUL;
AUDIT DROP USER BY ACCESS WHENEVER SUCCESSFUL;
AUDIT DROP USER BY ACCESS WHENEVER NOT SUCCESSFUL;
AUDIT DROP ANY TABLE BY ACCESS WHENEVER SUCCESSFUL;
AUDIT DROP ANY TABLE BY ACCESS WHENEVER NOT SUCCESSFUL;
AUDIT DROP TABLESPACE BY ACCESS WHENEVER SUCCESSFUL;
AUDIT DROP TABLESPACE BY ACCESS WHENEVER NOT SUCCESSFUL;