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