PSSERVPERM5_VW - Service Operation Permissions

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 Name Field Type Column Type Description

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

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

IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).

IB_INTGROUPSUBNAME Character(30) VARCHAR2(30) NOT NULL Integration Subgroup Name

IB_NOPERMISSIONS Character(1) VARCHAR2(1) NOT NULL No Permissions Exist
Y/N Table Edit
Default: N

IB_SERVICESECURITY Character(1) VARCHAR2(1) NOT NULL Service Operation Security

IB_REST_SERVICE Number(1,0) SMALLINT NOT NULL REST Service Type

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
IB_INTGROUPNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Group Name (see PSIBGROUPDEFN).
IB_INTGROUPSUBNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Subgroup Name
IB_NOPERMISSIONS	Character(1)	VARCHAR2(1) NOT NULL	No Permissions Exist Y/N Table Edit Default: N
IB_SERVICESECURITY	Character(1)	VARCHAR2(1) NOT NULL	Service Operation Security
IB_REST_SERVICE	Number(1,0)	SMALLINT NOT NULL	REST Service Type