PSIBSECURIT2_VW (SQL View)	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.

PSIBSECURIT2_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).

#	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	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
3	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).