Wednesday, July 9, 2014

Enable Audit in Oracle Database



select * from DBA_STMT_AUDIT_OPTS;


select * from DBA_OBJ_AUDIT_OPTS;


select * from DBA_AUDIT_TRAIL;

AUDIT ALL BY USER BY ACCESS;

AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY USER BY ACCESS;

SELECT * FROM audit_actions;

NOAUDIT  SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE;

NOAUDIT ALL;

TRUNCATE TABLE AUD$;

No comments:

Post a Comment