Wednesday, 2 March 2016

PeopleSoft Access Related SQL's

Access to Component:

Select AUTH.CLASSID As PERMISSION_LIST
, MNUI.MENUNAME
, PNLG.PNLGRPNAME As COMPONENT
, AUTH.DISPLAYONLY
, AUTH.AUTHORIZEDACTIONS

From PSAUTHITEM AUTH
, PSPNLGROUP PNLG
, PSMENUITEM MNUI

Where PNLG.PNLGRPNAME = 'Component Name'
AND AUTH.PNLITEMNAME = PNLG.ITEMNAME
AND AUTH.MENUNAME = MNUI.MENUNAME
AND AUTH.BARNAME = MNUI.BARNAME
AND AUTH.BARITEMNAME = MNUI.ITEMNAME
AND PNLG.PNLGRPNAME = MNUI.PNLGRPNAME

No comments:

Post a Comment