/* 用户直接授权 */
update t_perm_userpermdetail set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 角色的权限 */
update t_perm_rolepermdetial set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 禁用权限*/
update t_perm_disfunperm set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 业务角色补充授权*/
update t_perm_bizroleperm set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 业务角色禁用权限*/
update t_perm_bizroledisperm set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';

/*数据规则（旧）*/
update t_perm_datapermentry set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/*数据规则（新）*/
update t_perm_datarule set fbizappid = '0MRLNB/GDEG9' WHERE fentitynum in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
update t_perm_datarules_entry set fbizappid = '0MRLNB/GDEG9' WHERE fentitynum in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';


/*字段权限*/
update t_perm_fieldpermdetail set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 特殊数据权限 */
update t_perm_operationrule set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';
/* 特殊数据权限的规则和实体的关系 */
update t_perm_operationruleobj set fbizappid = '0MRLNB/GDEG9' WHERE FENTITYTYPEID in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid = '1QRCET0+7XJ9';


/* 管理员组 - 系统服务云管辖范围 */
update t_perm_admingroupfunperm set fappid='0MRLNB/GDEG9' where fentitynum in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fappid='1QRCET0+7XJ9';

/* 管理员策略功能权限详情 */
update t_perm_adminschemedetail set fbizappid='0MRLNB/GDEG9' where fentitynum in ('tbo_forwrateagree_rpt','tbo_rateswap_rpt','tbo_structdeposit_rpt','tbo_forextradecount_rpt','tbo_forextradedetail_rpt','tbo_pl_provision','tbo_plinfo') and fbizappid='1QRCET0+7XJ9';


