authorizedactions
8 更正
4 更新/全部显示
2 更新/显示
1 添加

displayonly
1 只显示
0 可编辑

 许可权列表页面权限:

SELECT OU.CLASSID AS 许可权列表,
MI.ITEMLABEL as 组件,
CO.ITEMLABEL as 页面,
case  OU.DISPLAYONLY when 1 then '只显示' when 0 then '可编辑' end,
ou.authorizedactions,
ou.*,
MI.*

FROM PSAUTHITEM OU, PSMENUITEM MI, PSPNLGROUP CO
WHERE OU.CLASSID = '许可权列表'
AND OU.MENUNAME = MI.MENUNAME
AND OU.BARNAME = MI.BARNAME
AND OU.BARITEMNAME = MI.ITEMNAME
AND MI.PNLGRPNAME = CO.PNLGRPNAME(+)
AND OU.PNLITEMNAME = CO.ITEMNAME(+)
AND OU.BARITEMNAME <> '%TEST%'

ORDER BY MI.ITEMLABEL

________________查询哪些用户对组件页面的权限--------------------------------------------------------------------------------

----------------------------用户对应的页面权限----------------------------------------------------------------------------------------------

SELECT DISTINCT  A.MENUNAME, A.BARITEMNAME,C.PNLGRPNAME, C.ITEMNAME, C.ITEMLABEL,a.displayonly,a.authorizedactions
  FROM PSAUTHITEM A, PSPNLGROUP C, PSROLECLASS R ,psroledefn ro
 WHERE A.PNLITEMNAME = C.Itemname(+)
   AND A.PNLITEMNAME = C.PNLGRPNAME(+)
   and r.rolename = ro.rolename
   AND R.CLASSID(+) = A.CLASSID
   and exists (select 1 from psroleuser t where t.rolename=r.rolename and t.roleuser='userid')
   ORDER BY A.MENUNAME, A.BARITEMNAME
   ;