Oracle Audit: differenze tra le versioni
Jump to navigation
Jump to search
Riga 10: | Riga 10: | ||
Per verificare quali eventi sono tracciati: |
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; |
|||
⚫ | |||
=Unified Audit= |
=Unified Audit= |
Versione delle 15:17, 4 dic 2019
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;