Hi ,
I have a dashboard with sectional access implementation based on the user's credentials,country,region.
I implemented the sheet level security based on the Qvuser() function & country,region.
So ,by doing this I am restricting the user from seeing only the data related to his specific country.
Now the problem is , my client is asking to add\delete user from the excel dynamically and the security should also reflect the same by restricting the user from viewing only his data .
Please tell me the best approach , I need to do so that the client can work independently after I complete the development.
ACCESS | USERID | PASSWORD | COUNTRY | LOB |
ADMIN | ADMIN | ADMIN | * | * |
USER | AMSUSER | AMSUSER | CHINA | AMS |
USER | AMSUSER | AMSUSER | AUSTRALIA | AMS |
USER | AMSUSER | AMSUSER | MALAYSIA | AMS |
USER | DIGITALUSER | DIGITALUSER | CHINA | DIGITAL |
USER | DIGITALUSER | DIGITALUSER | INDIA | DIGITAL |
USER | DIGITALUSER | DIGITALUSER | VIETNAM | DIGITAL |
USER | CHINAAMS | CHINAAMS | CHINA | AMS |
USER | CHINADIGITAL | CHINADIGITAL | CHINA | DIGITAL |
USER | AUSTRALIA | AUSTRALIA | AUSTRALIA | AMS |
USER | MALAYSIA | MALAYSIA | MALAYSIA | AMS |
USER | INDIA | INDIA | INDIA | DIGITAL |
USER | VIETNAM | VIETNAM | VIETNAM | DIGITAL |
| | | | |