
DELETE FROM T_PERM_USERPERMDETAIL WHERE FENTITYTYPEID = 'EB_REPORT_LIST' AND FBIZAPPID  = '/G4ZXY9/MISN' AND FPERMITEMID NOT IN ('47150e89000000ac','4715a0df000000ac');

UPDATE T_PERM_USERPERMDETAIL SET FPERMITEMID ='804f6478000000ac' WHERE FENTITYTYPEID = 'eb_report_list' AND FBIZAPPID  = '/G4ZXY9/MISN' AND FPERMITEMID = '4715a0df000000ac';

DELETE from t_perm_userpermdetail  WHERE fid IN (SELECT FID FROM t_perm_userperm  where FDIMTYPE = 'DIM_EPM_MODEL') AND FBIZAPPID = '/V0B8OWYDBZL';

DELETE from t_perm_userpermdetail where fentitytypeid = 'eb_currconvertupdate'and FBIZAPPID = '/V79VI+W05+V';

DELETE from t_perm_userpermdetail where fentitytypeid = 'bcm_tasklist'and FBIZAPPID = '/G4ZXY9/MISN';

DELETE from t_perm_userpermdetail where fentitytypeid = 'bcm_taskcatalog'and FBIZAPPID = '/G4ZXY9/MISN';

DELETE from t_perm_userpermdetail where fentitytypeid = 'bgc_apphome' and FBIZAPPID = '05VMP7NB3NVL';

DELETE from t_perm_userpermdetail where fentitytypeid = 'bgc_apphome' and FBIZAPPID = '05VMP7NB3NVL';

DELETE from t_perm_userpermdetail where fentitytypeid = 'bgm_protemplatelist' and FBIZAPPID = '/Y7WRJVSYD+N';

DELETE from t_perm_userpermdetail where fentitytypeid = 'eb_currconvertupdatelist' and FBIZAPPID = '/Y7WRJVSYD+N';

DELETE from t_perm_userpermdetail where fentitytypeid = 'eb_sharescheme_list' and FBIZAPPID = '/Y7WRJVSYD+N';

DELETE from t_perm_userpermdetail where fentitytypeid = 'eb_sharescheme_entity' and FBIZAPPID = '/Y7WRJVSYD+N';

DELETE from t_perm_userpermdetail where fentitytypeid = 'eb_sharescheme_group' and FBIZAPPID = '/Y7WRJVSYD+N';

UPDATE t_perm_userpermdetail  SET FENTITYTYPEID = 'epm_datasource' WHERE FENTITYTYPEID = 'bcm_datasourceedit' AND FBIZAPPID = '/V0B8OWYDBZL';

DELETE from t_perm_userpermdetail where fentitytypeid in ('bcm_tasklist','bcm_modelperm','bcm_dimension','bcm_memberperm_view','bcm_report_list','bcm_templatecatalog','bcm_user_assignperm','eb_examinelist','eb_task','eb_taskdecompose','eb_taskhome','eb_templatelist','eb_bizruleentity') and fbizappid = '/G4ZXY9/MISN';
