Which Roles can be used to grant access to a page?

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,
     PSPNLDEFN B,
     PSROLECLASS C
WHERE A.CLASSID = C.CLASSID
  AND A.PNLITEMNAME = B.PNLNAME
  AND A.PNLITEMNAME <> ' '
  AND B.PNLNAME = 'EP_APPRAISAL_EE'  --> Replace Page Name Here


No comments:

Post a Comment