User Tools

Site Tools


tech:psoft:ib_servop_sec

Create IB Service Operation Security.

PSAUTHWS contains the Permission list security for IB for each service operation we are using Z_CR_PT_BASE_USER permission list for all Service Operations.

INSERT INTO PSAUTHWS
SELECT DISTINCT 'Z_CR_PT_BASE_USER', A.IB_OPERATIONNAME , 4
FROM PSAUTHWS A 
WHERE NOT EXISTS (SELECT 'x' FROM PSAUTHWS WHERE CLASSID = 'Z_CR_PT_BASE_USER' AND IB_OPERATIONNAME = A.IB_OPERATIONNAME)

OR:

DELETE FROM PSAUTHWS WHERE CLASSID = 'Z_CR_PT_BASE_USER'
INSERT INTO PSAUTHWS 
SELECT 'Z_CR_PT_BASE_USER', IB.IB_OPERATIONNAME, 4
FROM PSOPERATION IB
tech/psoft/ib_servop_sec.txt · Last modified: 2024/06/21 12:04 by 127.0.0.1