PSAUTHWS_VW1 (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_IB.

PSAUTHWS_VW1

(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_IB.

SELECT IB_OPERATIONNAME , CLASSID , AUTHORIZEDACTIONS FROM PSAUTHWS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels
Default Value: 4

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