select distinct a.displayName 报表名称,d.realname 用户 from fine_authority_object a left join fine_authority b on a.id=b.authorityEntityId left join fine_user_role_middle c on b.roleid=c.roleid left join fine_user d on c.userid=d.id where b.authorityType=1 这个只能查到角色的用户,查不到用户列表.
|
1min目标场景问卷
立即参与
