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

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