Sheet Level Sectional Access

[mahesh_m1029488]

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