PTRCUSERPAGESEC

index back

User's Component Security

Reporting Console
SELECT DISTINCT A.OPRID , G.PNLGRPNAME FROM PSOPRDEFN A , PSROLECLASS B , PSROLEUSER C , PSAUTHITEM D , PSPGEACCESSDESC E , PSPNLGROUP F , PSMENUITEM G WHERE B.ROLENAME = C.ROLENAME AND D.MENUNAME = G.MENUNAME AND D.BARNAME = G.BARNAME AND D.BARITEMNAME = G.ITEMNAME AND F.PNLGRPNAME = G.PNLGRPNAME AND A.OPRID = C.ROLEUSER AND B.CLASSID = D.CLASSID AND D.MENUNAME NOT IN ('APPLICATION_DESIGNER','CLIENTPROCESS','DATA_MOVER','IMPORT_MANAGER','OBJECT_SECURITY','QUERY') AND D.MENUNAME NOT LIKE 'WEBLIB%' AND D.AUTHORIZEDACTIONS = E.AUTHORIZEDACTIONS

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19