--角色和对应表SELECT OB.DISPLAYNAME, OB.PATH, CR.ID, CR.NAME, AU.AUTHORITYTYPE, OB.EXPANDTYPEFROM REPORTCFG.FINE_AUTHORITY AU, REPORTCFG.FINE_AUTHORITY_OBJECT OB, REPORTCFG.FINE_CUSTOM_ROLE CRWHERE 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)