DBMS_FGA.ADD_POLICY

We have fga audit turned on specific views and columns

Below is a sample query used

EXECUTE DBMS_FGA.ADD_POLICY ( -

OBJECT_SCHEMA => 'APPS', -

OBJECT_NAME => 'RA_CUSTOMER_TRX_PARTIAL_V', -

POLICY_NAME => 'RA_CUSTOMER_TRX_PARTIAL_V_POL', -

AUDIT_COLUMN => 'RAC_BILL_TO_CUSTOMER_NAME, RAC_BILL_TO_CUSTOMER_NUM', -

AUDIT_CONDITION => 'SYS_CONTEXT(''USERENV'', ''CLIENT_IDENTIFIER'') NOT IN (''IBM-WS'',''SYSADMIN'')', -

ENABLE => TRUE, -

STATEMENT_TYPES => 'SELECT');

EXECUTE DBMS_FGA.ADD_POLICY ( -

OBJECT_SCHEMA => 'AR', -

OBJECT_NAME => 'HZ_PARTIES', -

POLICY_NAME => 'HZ_PARTIES_POL', -

AUDIT_COLUMN => 'PARTY_NUMBER, PARTY_NAME', -