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.
