查询支持继承的角色的权限

insert into role values (1,0,'guest','默认')
insert into role values (2,1,'dept','普通司局')
insert into role values (3,2,'dept','管理员')

select * from operation

insert into operation values(1,'登陆','')
insert into operation values(2,'浏览','')

insert into operation values(3,'新建','');
insert into operation values(4,'提交','');
insert into operation values(5,'发布','');
insert into operation values(6,'删除','');

insert into roleoperation values(1,1)

insert into roleoperation values(1,2)

insert into roleoperation values(2,3);
insert into roleoperation values(2,4);

insert into roleoperation values(3,5);
insert into roleoperation values(3,6);

select * from roleoperation
 
select r.roleid,r.proleid,r.name,rp.operationid,o.name from role r
join roleoperation  rp on r.roleid = rp.roleid
join operation o on rp.operationid = o.operationid

select r.roleid,o.name from(select * from role start with roleid=1 connect by prior  proleid = roleid)  r
join roleoperation  rp on r.roleid = rp.roleid
join operation o on rp.operationid = o.operationid


  select * from role start with roleid=3 connect by prior  proleid = roleid