Component Permission List Query

最新推荐文章于 2023-03-22 13:20:43 发布

weixin_34356555

最新推荐文章于 2023-03-22 13:20:43 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/GoDevil/archive/2008/08/07/1262757.html

本文提供了一段SQL查询代码，用于检索与特定组件关联的权限列表及其描述。通过连接多个表，如菜单定义、面板组定义和权限项，此查询能够详细列出所有相关的权限信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

An SQL that will identify permission lists along with permission lists description assigned to a specific component.

SELECT menu.menuname, compdfn.pnlgrpname, auth.classid permission_list,
CLASS.classdefndesc permission_desc
FROM psauthitem auth,
psmenudefn menu,
psmenuitem menuitm,
pspnlgroup comp,
pspnlgrpdefn compdfn,
psclassdefn CLASS
WHERE menu.menuname = menuitm.menuname
AND menuitm.pnlgrpname = comp.pnlgrpname
AND compdfn.pnlgrpname = comp.pnlgrpname
AND compdfn.pnlgrpname LIKE UPPER (:component_name)
AND auth.menuname = menu.menuname
AND auth.barname = menuitm.barname
AND auth.baritemname = menuitm.itemname
AND auth.pnlitemname = comp.itemname
AND auth.classid = CLASS.classid
GROUP BY menu.menuname, compdfn.pnlgrpname, auth.classid, CLASS.classdefndesc
ORDER BY menu.menuname, compdfn.pnlgrpname, permission_list;