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