create or replace procedure qj_qp.grant_to_u_qp_support_y
is
--该sp用于青浦常用表 对u_qp_support授权
begin
execute immediate'grant all on qj_qp.qp_iroot to u_qp_support';
execute immediate'grant all on qj_qp.qp_rh_prod_list to u_qp_support';
execute immediate'grant all on qj_qp.qp_iroot2019 to u_qp_support';
execute immediate'grant all on qj_qp.qp_zyqd_view to u_qp_support';--门店
execute immediate'grant all on qj_qp.qp_2019_prom_tp to u_qp_support';
execute immediate'grant all on qj_qp.qp_cdma_zk_fk to u_qp_support';
execute immediate'grant all on qj_qp.lh_2019_se1_result to u_qp_support';
execute immediate'grant all on qj_qp.qp_new_cdma to u_qp_support';
execute immediate'grant all on qj_qp.qp_prod_po_inst_2018 to u_qp_support';
execute immediate'grant all on qj_qp.v_qp_nf_yff_list to u_qp_support';
execute immediate'grant all on qj_qp.QP_2019_BUILD_ROAD to u_qp_support';--小区
execute immediate'grant all on qj_qp.QP_2019_XIAOQU_BASIC to u_qp_support';--小区
execute immediate'grant all on qj_qp.qp_irf to u_qp_support';
execute immediate'grant all on qj_qp.qp_irf_kd to u_qp_support';
execute immediate'grant all on qj_qp.qp_iruf to u_qp_support';
execute immediate'grant all on qj_qp.qp_mobile_czl to u_qp_support';--移动存增量
execute immediate'grant all on qj_qp.qp_wb_czl to u_qp_support';--宽带存增量
execute immediate'grant all on qj_qp.QPZQ_CBT_MANAGER_SALE_MD_QD to u_qp_support';--政企周报清单
end;