PSSERVPERM5_VW

index back

Service Operation Permissions

Used in the service administration component to retrieve defined service operations that are not Rest services with a value of 1. These do not require permissions to be set.
SELECT A.IB_SERVICENAME , A.IB_OPERATIONNAME , C.IB_INTGROUPNAME , C.IB_INTGROUPSUBNAME , ' ' , ' ' , B.IB_REST_SERVICE FROM PSSERVICEOPR A , PSOPERATION B , PS_PSIBALSRVGRP_VW C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_SERVICENAME = C.IB_SERVICENAME AND B.IB_REST_SERVICE <> 1

PeopleSoft Field NameField TypeColumn TypeDescription
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
IB_INTGROUPNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Group Name (see PSIBGROUPDEFN).
IB_INTGROUPSUBNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Subgroup Name
IB_NOPERMISSIONSCharacter(1)VARCHAR2(1) NOT NULLNo Permissions Exist

Y/N Table Edit

Default: N

IB_SERVICESECURITYCharacter(1)VARCHAR2(1) NOT NULLService Operation Security
IB_REST_SERVICENumber(1,0)SMALLINT NOT NULLREST Service Type
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19