ANALYSIS SECURITY
Here is the scenario:
3 different company dimensions, "Billing Country","Receiving Country","Main Country"
There are three companies in these dimensions: Canada, USA, Denmark. Now, in actuality there are more countries, but we'll keep it simple in this example.
This makes the possible combinations as follows:
BILLING COUNTRY RECEIVING COUNTRY MAIN COUNTRY
CANADA CANADA CANADA
CANADA CANADA USA
CANADA CANADA DENMARK
CANADA USA CANADA
CANADA USA USA
CANADA USA DENMARK
CANADA DENMARK CANADA
and so on and so forth, for every possible combination of the three countries and dimensions. I've only given 3 countries, but there are 20 countries, so you can imagine the different combinations.
Now, what they would like, is if the user has security to CANADA, they should have access to ALL combinations that have CANADA in it.
Any ideas on how this would be done?
Is it even possible?
[1739 byte] By [Mitch076] at [2008-3-6] 