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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OPRDEFNDESCCharacter(30)VARCHAR2(30) NOT NULLDescription field for a user
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19