Re: Listing of all OPRID's and the menus and rights assigned to t hem!

[Diwakar Bhatt <diwakar.v.bhatt@AC.COM>]

This was developed for version 6.0
SELECT A.MENUGROUP, A.MENULABEL, B.BARNAME, C.ITEMLABEL, D.ITEMLABEL,
A.MENUNAME, B.BARITEMNAME, B.PNLITEMNAME, B.DISPLAYONLY
  FROM PSMENUDEFN A, PSAUTHITEM B, PSMENUITEM C, PSPNLGROUP D
  WHERE C.MENUNAME = A.MENUNAME
    AND D.MENUNAME = C.MENUNAME
    AND D.ITEMNUM = C.ITEMNUM
    AND ( A.MENUNAME = B.MENUNAME
     AND B.OPRID = :1
     AND C.ITEMTYPE = 5
     AND C.BARNAME = B.BARNAME
     AND C.ITEMNAME = B.BARITEMNAME
     AND D.ITEMNAME = B.PNLITEMNAME )
  ORDER BY 1, 2, 3, 4