许可权列表对应页面的权限

SELECT OU.CLASSID AS 许可权列表,
MI.ITEMLABEL as 组件,
CO.ITEMLABEL as 页面,
OU.DISPLAYONLY,
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

许可权列表对应页面的权限

原文：https://www.cnblogs.com/binquan/p/permissionlist.html