Fine Grained Auditing

Hello,

I am actually working studying the Fine Grained Auditing.

My customer, would like integrate this feature in his new security strategy.

I enabled Fine Grained Auditing as follows:

BEGIN

dbms_fga.add_policy(object_schema=>'DWHIMR',

object_name=>'TD_TIE',

policy_name=>'aud_td_tie_dwhimr',

handler_schema=>NULL,

handler_module=>NULL,

enable=>TRUE,

statement_types=>'INSERT,UPDATE,DELETE,SELECT',

audit_trail=>DBMS_FGA.XML+DBMS_FGA.EXTENDED,

audit_column=>'LB_NOM_TIE',

audit_condition=>'VERIF_USER(USER) != ''OK''');

END;

/

As you can see, I submit as audit condition the name of a pl/sql function, called VERIF_USER.