BEGIN
  DBMS_FGA.add_policy(
    object_schema   => 'saturn',
    object_name     => 'sobterm',
    policy_name     => 'sobterm_aud',
    audit_column    => 'SOBTERM_REG_ALLOWED, SOBTERM_READM_REQ, SOBTERM_FEE_ASSESSMENT,
                        SOBTERM_FEE_ASSESSMNT_EFF_DATE, SOBTERM_DUPL_SEVERITY, 
                        SOBTERM_LINK_SEVERITY, SOBTERM_PREQ_SEVERITY, SOBTERM_CORQ_SEVERITY,
                        SOBTERM_TIME_SEVERITY, SOBTERM_CAPC_SEVERITY, SOBTERM_LEVL_SEVERITY,
                        SOBTERM_COLL_SEVERITY, SOBTERM_MAJR_SEVERITY, SOBTERM_CLAS_SEVERITY,
                        SOBTERM_APPR_SEVERITY, SOBTERM_MAXH_SEVERITY, SOBTERM_HOLD_SEVERITY,
                        SOBTERM_HOLD, SOBTERM_REFUND_IND, SOBTERM_BYCRN_IND, 
                        SOBTERM_REPT_SEVERITY, SOBTERM_RPTH_SEVERITY, SOBTERM_TEST_SEVERITY,
                        SOBTERM_CAMP_SEVERITY, SOBTERM_FEE_ASSESS_VR, SOBTERM_PRINT_BILL_VR,
                        SOBTERM_TMST_CALC_IND, SOBTERM_INCL_ATTMPT_HRS_IND, SOBTERM_CRED_WEB_UPD_IND,
                        SOBTERM_GMOD_WEB_UPD_IND, SOBTERM_LEVL_WEB_UPD_IND,
                        SOBTERM_CLOSECT_WEB_DISP_IND, SOBTERM_MAILER_WEB_IND, 
                        SOBTERM_SCHD_WEB_SEARCH_IND, SOBTERM_CAMP_WEB_SEARCH_IND, 
                        SOBTERM_SESS_WEB_SEARCH_IND, SOBTERM_INSTR_WEB_SEARCH_IND,
                        SOBTERM_FACSCHD_WEB_DISP_IND, SOBTERM_CLASLST_WEB_DISP_IND,
                        SOBTERM_OVERAPP_WEB_UPD_IND, SOBTERM_ADD_DRP_WEB_UPD_IND,
                        SOBTERM_DEGREE_SEVERITY, SOBTERM_PROGRAM_SEVERITY, 
                        SOBTERM_INPROGRESS_USAGE_IND, SOBTERM_GRADE_DETAIL_WEB_IND,
                        SOBTERM_MIDTERM_WEB_IND, SOBTERM_PROFILE_SEND_IND, 
                        SOBTERM_CUTOFF_DATE, SOBTERM_TIV_DATE_SOURCE, 
                        SOBTERM_WEB_CAPP_TERM_IND, SOBTERM_WEB_CAPP_CATLG_IND,
                        SOBTERM_ATTR_WEB_SEARCH_IND, SOBTERM_LEVL_WEB_SEARCH_IND,
                        SOBTERM_INSM_WEB_SEARCH_IND, SOBTERM_LS_TITLE_WEBS_DISP_IND,
                        SOBTERM_LS_DESC_WEBS_DISP_IND, SOBTERM_DURATION_WEB_SRCH_IND,
                        SOBTERM_LEVL_WEB_CATL_SRCH_IND, SOBTERM_STYP_WEB_CATL_SRCH_IND,
                        SOBTERM_COLL_WEB_CATL_SRCH_IND, SOBTERM_DIV_WEB_CATL_SRCH_IND,
                        SOBTERM_DEPT_WEB_CATL_SRCH_IND, SOBTERM_PROG_ATT_WEBC_SRCH_IND,
                        SOBTERM_LC_TITLE_WEBC_DISP_IND, SOBTERM_LC_DESC_WEBC_DISP_IND,
                        SOBTERM_DYNAMIC_SCHED_TERM_IND, SOBTERM_ASSESS_SWAP_IND,
                        SOBTERM_ASSESS_REV_NRF_IND, SOBTERM_ASSESS_REG_GRACE_IND,
                        SOBTERM_MINH_SEVERITY, SOBTERM_DEPT_SEVERITY, SOBTERM_ATTS_SEVERITY,
                        SOBTERM_CHRT_SEVERITY, SOBTERM_MEXC_SEVERITY, SOBTERM_STUDY_PATH_IND,
                        SOBTERM_FUTURE_REPEAT_IND, SOBTERM_SP_WEB_UPD_IND, 
                        SOBTERM_SECTIONFEE_IND',
    statement_types => 'INSERT, UPDATE, DELETE',
    enable          => TRUE);
END;
/

BEGIN
  DBMS_FGA.drop_policy(
    object_schema   => 'saturn',
    object_name     => 'sobterm',
    policy_name     => 'sobterm_aud');
END;
/
  • No labels