PSAUTHWS_VW2 (SQL View)	Index Back
Authorized Web Services View View to be used for select/update/insert into Web Services Security table - PSAUTHWS from security page - WS_ACCESS.

PSAUTHWS_VW2

(SQL View)

Authorized Web Services View

View to be used for select/update/insert into Web Services Security table - PSAUTHWS from security page - WS_ACCESS.

SELECT A.CLASSID , C.IB_SERVICENAME , A.IB_OPERATIONNAME , A.AUTHORIZEDACTIONS FROM PSAUTHWS A , PSOPERATION B , PSSERVICEOPR C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.IB_READONLY_PERM <> 1 AND B.IB_REST_SERVICE <> 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

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

4 AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
3	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
4	AUTHORIZEDACTIONS	Number(10,0)	DECIMAL(10) NOT NULL	Authorized Actions for Panels