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:

SELECT * FROM DBA_AUDIT_TRAIL;