A few things to look at with your example;
- All fields in the section access table must be in UPPER case
- You might want to have at least one ADMIN level user
- * represents all values listed in the reduction field, use a non existing value to represent all data values
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>
USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>
];
Section Application;
Try using USERID instead of NTNAME during your development work. That way you can impersonate your users in an easy way, by entering the USERID in the login credentials.
Section Access;
LOAD * INLINE [
ACCESS, USERID, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>
USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>
];
Section Application;
