用友U9数据库--用户对应的权限明细查询

-----用户对应的权限菜单----------------------------------------------------------------------------------------

select distinct a.name 组织,y.Name 用户,U.Name 用户组,b.Name 角色名称,d.Name,menuBETrl.DisplayName 菜单名称,
case authorityBE.Opinion when 0 then '拒绝' when 2 then '允许' end as 权限值   from Base_UserOrgRole x 
inner join base_role_trl b on x.role=b.id and b.SysMLFlag='zh-CN' and b.name<>'导出报表权限' and b.Name<>'OBA'
inner join base_role roleBE on x.role=roleBE.id
inner join Base_R