I am struggling with section access and was hoping some guidance to resolve my issue.
The highlighted fields all appear in a CLIENTMASTER table and below is an extract from my temporary section access file ( which does not work ). I say draft as the final version will use NTNAME rather than USERID and PASSWORD.
An employee can either be a "Servicer" - CLI_USERIDSERV or a CLI_USERIDINBR or both.
The intent is to grant access to the data where he/she is either the Servicer or the Broker of an Account irrespective of whoever the other colleague (Servicer/Broker) might be.
I also wish to grant ( in this case ) access to all clients in his department.
USERID
PASSWORD
SERIAL
ACCESS
NTNAME
CLI_DEPARTMENT
CLI_USERIDSERV
CLI_USERIDINBR
ABC
123
*
USER
*
*
ROCHEB01
*
ABC
123
*
USER
*
*
*
ROCHEB01
ABC
123
*
USER
*
DEPT1
*
*
XYZ
123
*
USER
*
*
FARREB01
*
XYZ
123
*
USER
*
*
BRADYP01
*
Could I please request some assistance with my challenge.
