select u.id, u.username, b.ROLEID, c.name, d.authorityEntityId, d.authorityEntityType, e.displayName from FINE_USER u left join FINE_USER_ROLE_MIDDLE b on u.id = b.userid left join FINE_CUSTOM_ROLE c on b.ROLEID = c.id left join FINE_AUTHORITY d on d.roleId = b.roleId left join FINE_AUTHORITY_OBJECT e on e.id = d.authorityEntityId where u.username = 'XX' and c.name is not null and d.authorityEntityType = 1 对应不出来每个用户能查看哪些报表的权限。
|
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
