157 lines
6.0 KiB
SQL
157 lines
6.0 KiB
SQL
PROMPT Grant table DWH to AML
|
|
|
|
DEFINE grantee = AML
|
|
|
|
GRANT SELECT ON a0cy_staging TO &grantee;
|
|
GRANT SELECT ON a1ao_staging TO &grantee;
|
|
GRANT SELECT ON a1id_staging TO &grantee;
|
|
GRANT SELECT ON a1in_staging TO &grantee;
|
|
GRANT SELECT ON a1ow_staging TO &grantee;
|
|
GRANT SELECT ON a2br_staging TO &grantee;
|
|
GRANT SELECT ON a2ne_staging TO &grantee;
|
|
GRANT SELECT ON a2tr_staging TO &grantee;
|
|
GRANT SELECT ON afrcu_staging TO &grantee;
|
|
GRANT SELECT ON ahasl_staging TO &grantee;
|
|
GRANT SELECT ON akerj_staging TO &grantee;
|
|
GRANT SELECT ON d5do_staging TO &grantee;
|
|
GRANT SELECT ON d8dh_staging TO &grantee;
|
|
GRANT SELECT ON h7ku_staging TO &grantee;
|
|
GRANT SELECT ON h8po_staging TO &grantee;
|
|
GRANT SELECT ON lhlon_staging TO &grantee;
|
|
GRANT SELECT ON lloan_staging TO &grantee;
|
|
GRANT SELECT ON m4cubi_staging TO &grantee;
|
|
GRANT SELECT ON m4cuc_staging TO &grantee;
|
|
GRANT SELECT ON m4cufr_staging TO &grantee;
|
|
GRANT SELECT ON m4cug_staging TO &grantee;
|
|
GRANT SELECT ON m4cui_staging TO &grantee;
|
|
GRANT SELECT ON m4cult_staging TO &grantee;
|
|
GRANT SELECT ON m4curl_staging TO &grantee;
|
|
GRANT SELECT ON m4cu_staging TO &grantee;
|
|
GRANT SELECT ON m5re_staging TO &grantee;
|
|
|
|
PROMPT Grant table DWH to BAGMIS
|
|
|
|
DEFINE grantee = BAGMIS
|
|
|
|
GRANT SELECT ON a0cy_staging TO &grantee;
|
|
GRANT SELECT ON a1gl_staging TO &grantee;
|
|
GRANT SELECT ON a2at_staging TO &grantee;
|
|
GRANT SELECT ON a2br_staging TO &grantee;
|
|
GRANT SELECT ON a2de_staging TO &grantee;
|
|
GRANT SELECT ON a2tr_staging TO &grantee;
|
|
GRANT SELECT ON d5do_staging TO &grantee;
|
|
GRANT SELECT ON d8dh_staging TO &grantee;
|
|
GRANT SELECT ON glbal_staging TO &grantee;
|
|
GRANT SELECT ON glhst_staging TO &grantee;
|
|
GRANT SELECT ON glplr_staging TO &grantee;
|
|
GRANT SELECT ON h7ku_staging TO &grantee;
|
|
GRANT SELECT ON h8ar_staging TO &grantee;
|
|
GRANT SELECT ON h8po_staging TO &grantee;
|
|
GRANT SELECT ON m4cug_staging TO &grantee;
|
|
GRANT SELECT ON m4cui_staging TO &grantee;
|
|
GRANT SELECT ON m4cu_staging TO &grantee;
|
|
GRANT SELECT ON m5re_staging TO &grantee;
|
|
GRANT SELECT ON mrtt1rk_staging TO &grantee;
|
|
GRANT SELECT ON x9xcg_staging TO &grantee;
|
|
GRANT SELECT ON fx_ext TO &grantee;
|
|
GRANT SELECT ON fx_staging TO &grantee;
|
|
GRANT SELECT ON mm_ext TO &grantee;
|
|
GRANT SELECT ON mm_staging TO &grantee;
|
|
GRANT SELECT ON alco_staging TO &grantee;
|
|
GRANT SELECT ON hist_saldo_tab TO &grantee;
|
|
GRANT SELECT ON gl_saldo_tab TO &grantee;
|
|
GRANT SELECT ON kredit_tab TO &grantee;
|
|
GRANT SELECT ON agunan_tab TO &grantee;
|
|
GRANT SELECT ON kredit_curr_rate_tab TO &grantee;
|
|
|
|
PROMPT Grant table DWH to SIGMALBU
|
|
|
|
DEFINE grantee = SIGMALBU
|
|
|
|
GRANT SELECT ON a0cy_staging TO &grantee;
|
|
GRANT SELECT ON a0ho_staging TO &grantee;
|
|
GRANT SELECT ON a0wi_staging TO &grantee;
|
|
GRANT SELECT ON a1bs_staging TO &grantee;
|
|
GRANT SELECT ON a1ec_staging TO &grantee;
|
|
GRANT SELECT ON a1fa_staging TO &grantee;
|
|
GRANT SELECT ON a1gl_staging TO &grantee;
|
|
GRANT SELECT ON a1lo_staging TO &grantee;
|
|
GRANT SELECT ON a2at_staging TO &grantee;
|
|
GRANT SELECT ON a2br_staging TO &grantee;
|
|
GRANT SELECT ON a2de_staging TO &grantee;
|
|
GRANT SELECT ON a2is_staging TO &grantee;
|
|
GRANT SELECT ON a2ku_staging TO &grantee;
|
|
GRANT SELECT ON d5do_ext TO &grantee;
|
|
GRANT SELECT ON d5do_staging TO &grantee;
|
|
GRANT SELECT ON d6dd_staging TO &grantee;
|
|
GRANT SELECT ON d6kol_staging TO &grantee;
|
|
GRANT SELECT ON d8dh_staging TO &grantee;
|
|
GRANT SELECT ON d8pjm_staging TO &grantee;
|
|
GRANT SELECT ON dloan_staging TO &grantee;
|
|
GRANT SELECT ON fcadkhu_staging TO &grantee;
|
|
GRANT SELECT ON fcadkrt_staging TO &grantee;
|
|
GRANT SELECT ON fcadumu_staging TO &grantee;
|
|
GRANT SELECT ON fcadurt_staging TO &grantee;
|
|
GRANT SELECT ON glbal_staging TO &grantee;
|
|
GRANT SELECT ON glhst_staging TO &grantee;
|
|
GRANT SELECT ON glplr_staging TO &grantee;
|
|
GRANT SELECT ON h7ku_staging TO &grantee;
|
|
GRANT SELECT ON h8arr_staging TO &grantee;
|
|
GRANT SELECT ON h8ar_staging TO &grantee;
|
|
GRANT SELECT ON h8du_staging TO &grantee;
|
|
GRANT SELECT ON h8po_staging TO &grantee;
|
|
GRANT SELECT ON lclcd_staging TO &grantee;
|
|
GRANT SELECT ON lcomn_staging TO &grantee;
|
|
GRANT SELECT ON lcoms_staging TO &grantee;
|
|
GRANT SELECT ON lcpap_staging TO &grantee;
|
|
GRANT SELECT ON lfacu_staging TO &grantee;
|
|
GRANT SELECT ON lfcms_staging TO &grantee;
|
|
GRANT SELECT ON lfcty_staging TO &grantee;
|
|
GRANT SELECT ON lfsbi_staging TO &grantee;
|
|
GRANT SELECT ON lgaik_staging TO &grantee;
|
|
GRANT SELECT ON lgtpa_staging TO &grantee;
|
|
GRANT SELECT ON lhfac_staging TO &grantee;
|
|
GRANT SELECT ON lhlon_staging TO &grantee;
|
|
GRANT SELECT ON lhpdu_staging TO &grantee;
|
|
GRANT SELECT ON llnty_staging TO &grantee;
|
|
GRANT SELECT ON lloan_staging TO &grantee;
|
|
GRANT SELECT ON llonbg_staging TO &grantee;
|
|
GRANT SELECT ON lmcom_staging TO &grantee;
|
|
GRANT SELECT ON lmecom_staging TO &grantee;
|
|
GRANT SELECT ON lsabi_staging TO &grantee;
|
|
GRANT SELECT ON ltlon_staging TO &grantee;
|
|
GRANT SELECT ON m4cuc_staging TO &grantee;
|
|
GRANT SELECT ON m4cug_staging TO &grantee;
|
|
GRANT SELECT ON m4cui_staging TO &grantee;
|
|
GRANT SELECT ON m4cu_staging TO &grantee;
|
|
GRANT SELECT ON m5pj_staging TO &grantee;
|
|
GRANT SELECT ON m5reprk_staging TO &grantee;
|
|
GRANT SELECT ON m5re_staging TO &grantee;
|
|
GRANT SELECT ON m6hi_staging TO &grantee;
|
|
GRANT SELECT ON m6ib_staging TO &grantee;
|
|
GRANT SELECT ON m6sb_staging TO &grantee;
|
|
GRANT SELECT ON m6si_staging TO &grantee;
|
|
GRANT SELECT ON r6kol_staging TO &grantee;
|
|
GRANT SELECT ON rloan_staging TO &grantee;
|
|
GRANT SELECT ON t6dt_staging TO &grantee;
|
|
GRANT SELECT ON t_reconcile_staging TO &grantee;
|
|
|
|
PROMPT Grant table DWH to WSTMT
|
|
|
|
DEFINE grantee = WSTMT
|
|
|
|
GRANT SELECT ON a0cy_staging TO &grantee;
|
|
GRANT SELECT ON a0mo_staging TO &grantee;
|
|
GRANT SELECT ON a2at_staging TO &grantee;
|
|
GRANT SELECT ON a2br_staging TO &grantee;
|
|
GRANT SELECT ON a2ku_staging TO &grantee;
|
|
GRANT SELECT ON a2tr_staging TO &grantee;
|
|
GRANT SELECT ON a3fi_staging TO &grantee;
|
|
GRANT SELECT ON h7ku_staging TO &grantee;
|
|
GRANT SELECT ON h8po_staging TO &grantee;
|
|
GRANT SELECT ON hist_saldo_tab TO &grantee;
|
|
GRANT SELECT ON m4cuc_staging TO &grantee;
|
|
GRANT SELECT ON m4cug_staging TO &grantee;
|
|
GRANT SELECT ON m4cui_staging TO &grantee;
|
|
GRANT SELECT ON m4cu_staging TO &grantee;
|
|
GRANT SELECT ON m5re_staging TO &grantee; |