Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
npatel1
Contributor II
Contributor II

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

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.

Labels (1)
0 Replies