泛微Ecology E8 E9根据用户ID查询所属角色或根据角色查角色成员

–根据角色ID查询用户权限
select * from SystemRightRoles a,SystemRights b where a.rightid=b.id
and roleid=2

–根据用户ID查询用户所属角色
select resourceid,roleid,rolesmark from HrmRoles a ,HrmRoleMembers b where a.id=b.roleid
and resourceid=4

–根据角色ID查询所有的用户
select resourceid,roleid,rolesmark from HrmRoles a ,HrmRoleMembers b where a.id=b.roleid
and b.roleid=2

–根据用户ID查询对应的角色及权限
select d.resourceid,a.rightid,b.rightdesc,a.roleid,c.rolesmark
from SystemRightRoles a,SystemRights b ,HrmRoles c,HrmRoleMembers d
where a.rightid=b.id and c.id=a.roleid and c.id=d.roleid
and d.resourceid=4

–其他
select * from SystemRights where id=106
select * from SystemRightDetail where rightdetail like ‘%SystemRightRoles%’
select * from SystemRightDetail where rightdetail like ‘%HrmRoles%’
select * from SystemRightDetail where rightdetailname like ‘%角色%’