Component Permission List Query

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;

转载于:https://www.cnblogs.com/GoDevil/archive/2008/08/07/1262757.html