--角色和对应表

SELECT

 OB.DISPLAYNAME,

 OB.PATH,

 CR.ID,

 CR.NAME,

 AU.AUTHORITYTYPE,

 OB.EXPANDTYPE

FROM

 REPORTCFG.FINE_AUTHORITY AU,

 REPORTCFG.FINE_AUTHORITY_OBJECT OB,

 REPORTCFG.FINE_CUSTOM_ROLE CR

WHERE

 1=1

 AND AU.AUTHORITYENTITYID = OB.ID 

 AND AU.ROLEID = CR.ID

--角色

 AND CR.ID IN ('1086a39e-2cdc-4dce-9ea3-a7f329cf5481')

-- 权限类型为 FineReport 模板查看权限

AND AU.AUTHORITYTYPE = '1'

-- 扩展类型为 FineReport 报表

AND OB.EXPANDTYPE = '102'

--AND DBMS_LOB.SUBSTR(OB.PATH, 4000, 1) LIKE '%实时销售%'

ORDER BY

 DBMS_LOB.SUBSTR(OB.PATH, 4000, 1)