${if(or(fr_authority='角色1',fr_authority='角色2',fr_authority='角色3'),"selcet * from 表A where xxx",if(or(fr_authority='角色4',fr_authority='角色5'),"selcet * from 表B where xxx",if(fr_authority='角色5',"selcet * from 表C where xxx","")))}

这个建议，现在Oracle先直接把数据处理成一个视图，然后帆软直接根据角色在视图过滤数据，这样最高效

可以参考一下：

select

*

from 表

where 1=1

${if(fine_username = "角色1" || fine_username = "角色2" || fine_username = "角色3","and 字段A in (select distinct 字段 from 表A where 角色名称 = '"+fine_username+"')",

if(fine_username = "角色4","and 字段B in (select distinct 字段 from 表B where 角色名称 = '"+fine_username+"')","and 字段C in (select distinct 字段 from 表C where 角色名称 = '"+fine_username+"')"))}