Oracle Audit

Audit Classico

Da manualistica: "Oracle recommends that you include the BY ACCESS clause for all AUDIT statements, which results in a more detailed audit record."

Impostazioni minime (12.2):

AUDIT SESSION BY ACCESS;
AUDIT DBA BY ACCESS;
AUDIT ALL STATEMENTS BY <username> BY ACCESS;

Per verificare quali eventi sono tracciati:

set linesize 200 pagesize 200
col user_name for a20
col proxy_name for a20
SELECT * from DBA_STMT_AUDIT_OPTS;
SELECT * FROM DBA_PRIV_AUDIT_OPTS;
SELECT * FROM DBA_OBJ_AUDIT_OPTS;