select_user_role_set.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 15 行

select roleid,rolename from rolelist
 where roleid  in
(select roleid   
 from UserRoles a left outer join Userlist b 
 on a.userid=b.userid 
 where b.username='admin'
 ) --当前用户已设置的角色
 
select roleid,rolename from rolelist
where roleid not in
(select roleid from userRoles a 
 left outer join userlist b 
 on a.userid=b.userid
 where b.username='admin')
--当前用户没有设置的角色