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
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