Use of fine-grained oracle Auditing

Use of fine-grained oracle Auditing
Take the scott user's emp table as an Example

---- Add a policy
Begin
DBMS_FGA.ADD_POLICY (
Object_schema => 'Scott ',
Object_name => 'emp ',
Policy_name => 'mydomainy1 ',
Handler_schema => NULL,
Handler_module => NULL,
Enable => TRUE,
Statement_types => 'insert, UPDATE, delete ',
Audit_column_opts => DBMS_FGA.ANY_COLUMNS );
End;

---- Enable policy
Begin
DBMS_FGA.ENABLE_POLICY (
Object_schema => 'Scott ',
Object_name => 'emp ',
Policy_name => 'mydomainy1 ',
Enable => TRUE );
End;

Select * from dba_fga_audit_trail;
Select * from dba_audit_policies;

Select db_user, timestamp, SQL _text, SQL _bind from dba_fga_audit_trail; -- Audit Result

SELECT text FROM dba_Views where view_name = upper ('dba _ FGA_AUDIT_TRAIL '); -- view records


---- Deletion policy
Begin
Dbms_fga.drop_policy (
Object_schema => 'Scott ',
Object_name => 'emp ',
Policy_name => 'mydomainy1'
);
End;