Hi, I would like to know if this scenario is possible.
Assume the following:
- Extra rows were created above User1 for "Dummy" user that lists all possible values for Dim1 and Dim2
- Dim1 and Dim2 have more values not listed in the sample below.
- Below is how the section access table is written for User1
| ACCESS | NTNAME | DIM1 | DIM2 |
|---|
USER | User1 | * | DIM2VALUE1 |
| USER | User1 | * | DIM2VALUE2 |
| USER | User1 | * | DIM2VALUE3 |
| USER | User1 | DIM1VALUE1 | * |
I know that here, User1 will have access to all values for DIM1 and DIM2. But what I would like to happen is that the user will have access to all DIM1 values related to DIM2 values 1-3, but for DIM1VALUE1 it should have access to all DIM2 values related to it. Like DIM1VALUE1 can have DIM2VALUE4, I want to be able to see that, but if DIM1VALUE2 also have DIM2VALUE4 I don't want to see that. Is this possible with section access? If not, do you have an advice to how security should be implemented here?
Thanks,
Roebrich Perez
