Section Access

[arvindjha2050]

Hello Team,

I have come across a following scenario

ACCESS USERID GEOGRAPHY COUNTRY

ADMIN    1            *                    *

USER      2           EUROPE        SPAIN

USER      3           EUROPE        *

For the above case section access works for Admin and user with ID 2 but not for user 3.

For user 3 we want him to have access to all countries of Europe and hence * for COUNTRY.We also tried with blank but with no avail.

Thanks,

Arvind

[Gysbert_Wassenaar]

I think you'll that for user 3 you'll have to add a line for each county in europe 1). The * means all listed values and the table now only lists spain. Leaving it empty doesn't work as you've noticed. User 1 has ADMIN access so it always gets access to all the data.

1) Or create a new data table in your model that links the users to the regions they should be able to see. Basically doing the same thing, but in a different table

[arvindjha2050]

Thanks for the reply.

Yes this works and has been tested but it makes the whole thing very long.

Just imagine a case of Europe Geography and 20 countries beneath it , we need to have 20 entries for same.

[arvindjha2050]

Just a confirmation

ACCESS	USERID	GEOGRAPHY	COUNTRY
ADMIN	1	*	*
USER	2	EUROPE	SPAIN
USER	3	EUROPE	FRANCE
USER	4	EUROPE	GERMANY
USER	5	EUROPE	*

in this case i think User with UserID 5 will have access to Spain ,France and Germany.which means if i have a particular user assigned for each and every country in a particular geography we can have Head of that geography at last mentioning *.

Am i correct in my inference?

Thanks,

Arvind

[Gysbert_Wassenaar]

Yes, that's correct.