PSSERVPERM_VW

(SQL View)
 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 , ' ' , ' ' , ' ' , ' ' , ' ' , B.IB_REST_SERVICE FROM PSSERVICEOPR A , PSOPERATION B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND B.IB_REST_SERVICE <> 1 AND B.PTIBAPPLNAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
2 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
3 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
4 IB_INTGROUPSUBNAME Character(30) VARCHAR2(30) NOT NULL Integration Subgroup Name
5 IB_NOPERMISSIONS Character(1) VARCHAR2(1) NOT NULL No Permissions Exist

Y/N Table Edit

Default Value: N

6 IB_SERVICESECURITY Character(1) VARCHAR2(1) NOT NULL Service Operation Security
7 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
8 IB_REST_SERVICE Number(1,0) SMALLINT NOT NULL REST Service Type