Oracle -audit komutları

select * from SYS.AUD$
select * from DBA_AUDIT_TRAIL

DELETE FROM SYS.AUD$;

SELECT sql_text FROM dba_common_audit_trail;
-------------------------------
AUDIT ALL BY sapsr3

AUDIT SESSION BY sapsr3 by access;

AUDIT SELECT TABLE, UPDATE TABLE BY SAPSR3 BY ACCESS;

AUDIT select ANY TABLE;

AUDIT SELECT, INSERT, DELETE
ON sapsr3.vbak
BY ACCESS
WHENEVER SUCCESSFUL;
----------------------------
select * from sys.fga_log$


AUDIT SESSION
BY SAPSR3

NOAUDIT session;

NOAUDIT ALL;


SELECT * FROM DBA_PRIV_AUDIT_OPTS; -- aktif auditleri gosterir.

http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/cfgaudit.htm