AUDIT EXAMPLES with queries

AUDIT Examples
*****************


SELECT username, extended_timestamp, owner, obj_name, action_name FROM   dba_audit_trail WHERE  owner = 'CMICH' and action_name='DELETE' ORDER BY timestamp;


1.SELECT username, extended_timestamp, owner, obj_name, action_name FROM   dba_audit_trail WHERE  owner = 'CMICH' and obj_name='QP_SETTLEMENT_BATCH' ORDER BY timestamp;


2.SELECT db_user,extended_timestamp, object_schema, object_name, action FROM   v$xml_audit_trail WHERE  object_schema = 'QP_AUTH' ORDER BY extended_timestamp;


3.SELECT sql_text FROM   dba_fga_audit_trail;



BEGIN
  DBMS_FGA.add_policy(
    object_schema   => 'AUDIT_TEST',
    object_name     => 'EMP',
    policy_name     => 'SALARY_CHK_AUDIT',
    audit_condition => 'SAL > 50000',
    audit_column    => 'SAL',
    handler_schema  => 'AUDIT_TEST',
    handler_module  => 'FIRE_CLERK',
    enable          => TRUE);
END;
/


For other auditing options please refer my blog