Oracle Audit: differenze tra le versioni
Jump to navigation
Jump to search
| Riga 15: | Riga 15: | ||
SELECT * from DBA_STMT_AUDIT_OPTS; |
SELECT * from DBA_STMT_AUDIT_OPTS; |
||
SELECT * FROM DBA_PRIV_AUDIT_OPTS; |
SELECT * FROM DBA_PRIV_AUDIT_OPTS; |
||
col owner for a20 |
|||
col object_name for a20 |
|||
SELECT * FROM DBA_OBJ_AUDIT_OPTS; |
SELECT * FROM DBA_OBJ_AUDIT_OPTS; |
||
Versione delle 15:18, 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;
col owner for a20 col object_name for a20 SELECT * FROM DBA_OBJ_AUDIT_OPTS;