PSAUTHWS_VW2

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.
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 NameField TypeColumn TypeDescription
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
AUTHORIZEDACTIONSNumber(10,0)DECIMAL(10) NOT NULLAuthorized Actions for Panels
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19