权限管理系统设计

select * from SYS_USER;--用户
select * from SYS_USER_ROLE;--用户&角色
select * from SYS_ROLE;--角色
select * from SYS_ROLE_MENU;--角色-菜单
select * from SYS_MENU;--菜单
select
       tbl1.LOGIN_NAME,
       tbl2.USER_ID, tbl2.ROLE_ID,
       tbl3.NAME,
       tbl4.MENU_ID,
       tbl5.NAME
from
  (
select ID,LOGIN_NAME from SYS_USER where id='1609'
  ) tbl1
left join
  SYS_USER_ROLE tbl2
on tbl1.ID=tbl2.USER_ID
left join
    SYS_ROLE tbl3
on tbl2.ROLE_ID=tbl3.ID
left join
  SYS_ROLE_MENU tbl4
on tbl4.ROLE_ID=tbl3.ID
left join
  SYS_MENU tbl5
on tbl5.ID=tbl4.MENU_ID