SELECT DISTINCT
C.ROLENAME,
A.MENUNAME,
A.BARITEMNAME as Component_Name,
A.PNLITEMNAME as Page_Name,
case when A.DISPLAYONLY = 0 then 'Read/Write' else 'Read Only' end as Display_Mode,
(SELECT D.PAGEACCESSDESCR FROM PSPGEACCESSDESC D WHERE D.AUTHORIZEDACTIONS = A.AUTHORIZEDACTIONS) as Authorized_Actions
FROM PSAUTHITEM A,
PSPNLGROUP B,
PSROLECLASS C
WHERE A.CLASSID = C.CLASSID
AND A.BARITEMNAME = B.PNLGRPNAME
AND A.BARITEMNAME <> ' '
AND B.PNLGRPNAME = 'EP_APPRAISAL_APPR' --> Replace Component Name Here
No comments:
Post a Comment