决策平台上明明有这么多的模板权限,为啥我在内置数据库里查出来就只有几个,而且还是错误的。如下图 查询sql奉上: SELECT c.realName,c.userName,d.displayName FROM `fine_authority` a left join fine_user_role_middle b on a.roleId = b.roleId left join fine_user c on b.userId = c.id left join fine_authority_object d on a.authorityEntityId=d.id where d.expandType='102' and c.userName = '${username}' and a.authorityEntityType=0 group by c.realName,c.userName,d.displayName 来大佬帮我看看~!来大佬看一眼啊!~ |