Hi
I have the following scenario: User Group B is a member group of User Group A. In A, security should be less restrictive then in B. For example, users in A can see everything within a country while users in B can see only their state. The problem is that those two filters are combined by an OR clause in B as in:
Select SUM(Sales) From FactTable
Where (Country ='US' OR State='CA')
which gives the same result as:
Select SUM(Sales) From FactTable
Where Country ='US'
Is there a way to change the way the filers are combined?
If I don't create B as a member of A then the number of groups under User Manager gets very large and I need to define privileges for each group. We are in version 7.2.0 and we have 7.i security model.
Thanks, OV
I have the following scenario: User Group B is a member group of User Group A. In A, security should be less restrictive then in B. For example, users in A can see everything within a country while users in B can see only their state. The problem is that those two filters are combined by an OR clause in B as in:
Select SUM(Sales) From FactTable
Where (Country ='US' OR State='CA')
which gives the same result as:
Select SUM(Sales) From FactTable
Where Country ='US'
Is there a way to change the way the filers are combined?
If I don't create B as a member of A then the number of groups under User Manager gets very large and I need to define privileges for each group. We are in version 7.2.0 and we have 7.i security model.
Thanks, OV