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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19