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



Answer this question

ANALYSIS SECURITY

  • ANALYSIS SECURITY