I have the following situation for role hierarchy:
World
|
-------------
| |
Europe Asia
| |
------------- -------------
| | | | | |
RU Ger Fra Jap Ch S.Kor
|
------
| |
Mos St.pet
| | | | |
At the top most level I have a user how has the right to see all. Followed by continents and then countries, cities and so on.
If you are a head at a country level, lets say Russia, you should be able to see only the records created by your subordinates at city level, that is Moscow and St. Petersburg. The same restrictions at city level applies. That is, a user belonging to a particular city should view records belonging to his subordinates and not that of his neighbouring cities subordiates' records, even if they belong to the same country.
I can achieve this with role hierarchy. But if I have all 7 continents and around 50 countries, must I create a role for each of the 50 countries and numerous cities? Or is there another way?