OpenJWeb快速開發(fā)平臺中實現(xiàn)了上級組織結(jié)構(gòu)下的人員可獲得下級組織結(jié)構(gòu)的權(quán)限,sql:

create or replace view v_user_auth as
--select distinct user_id,login_id,comm_code,auth_name,auth_resource from (
select a.user_id,a.login_id,b.comm_code,b.auth_name,b.auth_resource from
comm_user a,comm_auth b ,comm_user_auth c
where c.user_id = a.user_id
and c.auth_id = b.auth_id
union
select a.user_id,a.login_id,b.comm_code,b.auth_name,b.auth_resource from
comm_user a,comm_auth b , comm_user_role d,comm_role_auth e
where a.user_id = d.user_id
and d.role_id = e.role_id
and e.auth_id = b.auth_id

union

select a.user_id,a.login_id,b.comm_code,b.auth_name,b.auth_resource from (
select a.user_id,a.login_id,b.row_id row_id,b.tree_code from comm_user a,comm_dept b where a.dept_id=b.pk_id union
select a.user_id,c.login_id,a.org_id row_id,b.tree_code from comm_org_emp_rel a,comm_dept b,comm_user c where b.row_id = a.org_id and c.dept_id=b.pk_id) a,
(
select a.dept_id,c.auth_id,b.tree_code,c.comm_code ,c.auth_name,c.auth_resource from comm_dept_auth a,comm_dept b,comm_auth c where a.dept_id =b.row_id
and a.auth_id=c.auth_id) b
where? b.tree_code like a.tree_code ||'%'? ;

例如下級組織結(jié)構(gòu)001001具有某功能的權(quán)限,則上級組織結(jié)構(gòu)001則可獲得此功能的權(quán)限,如果用戶A屬于001部門,則

此用戶可獲得分配給001001組織的權(quán)限.使用spring security框架可以從這個視圖中獲取權(quán)限記錄.

OpenJWeb快速開發(fā)平臺組織結(jié)構(gòu)繼承權(quán)限的實現(xiàn)