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 Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20