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; /