Component Permission List Query

Your rating: None Average: 3.4 (5 votes)

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;

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!


Have a question? Please ask it on the forum instead.
Guest's picture
Guest (not verified)
Re: Component Permission List Query

Thanks for the query. This really helped me out.