HC_SMPLUSR_SRCH

(SQL View)
 Index Back

User ID search view

This is a dynamic view because if it is made a regular view, it is trated as a security view, ie, a where clause is added.

SELECT O.OPRID , O.OPRDEFNDESC FROM PSOPRDEFN O WHERE O.OPRID NOT IN ('PS','PSEM','PSBASS','PTWEBSERVER','PSSEC') AND NOT EXISTS ( SELECT 'X' FROM PSROLEUSER U ,PS_SMPL_ROLE_NOACC R WHERE U.ROLEUSER = O.OPRID AND U.ROLENAME = R.ROLENAME) AND NOT EXISTS ( SELECT 'X' FROM PSROLEUSER U ,PSROLECLASS R , PSAUTHITEM A WHERE U.ROLEUSER=O.OPRID AND U.ROLENAME=R.ROLENAME AND R.CLASSID = A.CLASSID AND (A.MENUNAME LIKE 'APPLICATION_DESIGNER%' OR A.MENUNAME LIKE 'DATA_MOVER%'))

# 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 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user