PSIBSECURIT2_VW

index back

IB Security View

Used to tag IB Service Operations with security. Only users with security to Service Operations can invoke and view the information in the monitor.
SELECT DISTINCT A.OPRID , B.CLASSID , B.IB_OPERATIONNAME FROM PSOPRCLS A , PSAUTHWS B WHERE A.OPRCLASS = B.CLASSID AND B.AUTHORIZEDACTIONS = 4

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19