PTRCUSERPAGESEC

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name