HC_SMPLUSR_SRCH

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 Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19