How to provide Authorization access for a field based on sub String characters

npatel1 — Wed, 29 Jan 2025 16:21:29 GMT

I have setup Authorization xlsx file that provides the users security access.

The parameters are based on the field names.

ACCESS

USER.EMAIL

COMPANY_CODE

MATERIAL

The material access is based on substring. e.g. for below Product codes, I want to give User A access to

*NUM* materials only.

ProdCod ProdNm

CVSCOMM89390156	(vescell-200)hydroxypropyl Methyl Cellul
CVSCOMM893220877	Hbel-128 - 1200 Kg Ibc
CVSNUMCOBD9032422	Mh-em100x
CVSNUMCOBD9032422	Mh-em100x
CVSNUMCOMM89390155	(vescell-100)hydroxypropyl Methyl Cellul
CVSCOMM89320500	Vinnapas 4240 N 25kg
CVSCOMM89380471	Ls-age Alkyl (c12-c14) Glycidyl Ether
CVSCOMM89380493	Citric Acid Anh. China-25kg.
CVSCOMM89380471	Ls-age Alkyl (c12-c14) Glycidyl Ether
CVSBCIC57420982	Baxxodur Ec 301
CVSBEMO50201334	Dehyton Pk 45 Bulk Direct
CVSCOMM89320500	Vinnapas 4240 N 25kg

How do I update the Authorzation.xlsx for Material column so that User A has access to "NUM" materials only.

topic How to provide Authorization access for a field based on sub String characters in Management & Governance