SET PAGES 100
TTITLE 'Currently Active FGA Policies|(FROM DBA_AUDIT_POLICIES)'

COL object_schema   FORMAT A20      HEADING 'Object|Schema'
COL object_name     FORMAT A30      HEADING 'Object Name' WRAP
COL policy_name     FORMAT A16      HEADING 'Policy Name' WRAP
COL policy_text     FORMAT A24      HEADING 'Policy Text' WRAP
COL policy_column   FORMAT A16      HEADING 'Policy Column' WRAP
COL enabled         FORMAT A05      HEADING 'On?'
COL siud_options    FORMAT A04      HEADING 'SIUD|Set'
SELECT 
     policy_name
    ,policy_text
    ,policy_column
    ,enabled
    ,object_schema
    ,object_name
    ,DECODE(sel,'YES','Y','N') || DECODE(ins,'YES','Y','N')||
     DECODE(upd,'YES','Y','N') || DECODE(del,'YES','Y','N') siud_options
    ,PF_SCHEMA
    ,PF_PACKAGE
    ,PF_FUNCTION
  FROM dba_audit_policies;
TTITLE OFF