用户角色权限

为什么80%的码农都做不了架构师？>>>   

-- 查询用户角色
select u.name as '用户名',r.name as '角色名' from user u join user_role ur on u.user_id = ur.user_id join role r on r.role_id = ur.role_id where u.name = 'admin'

-- 查询用户权限
select u.name as '用户名',r.name as '角色名',p.name as '权限' from user u
 join user_role ur on u.user_id = ur.user_id
  join role r on r.role_id = ur.role_id
 join role_permission rp on r.role_id = rp.role_id
  join permission p on rp.permission_id = p.permission_id
where u.name = 'admins'

--查询用户菜单

select u.name as '用户名',r.name as '角色名',p.name as '权限' ,m.name as '菜单' from user u
 join user_role ur on u.user_id = ur.user_id
  join role r on r.role_id = ur.role_id
 join role_permission rp on r.role_id = rp.role_id
  join permission p on rp.permission_id = p.permission_id
 join permision_menu pm on p.permission_id = pm.permission_id
  join menu m on pm.menu_id = m.menu_id
where u.name = 'admins'

 

转载于:https://my.oschina.net/wamdy/blog/130140