Hi i'm struggling to understand and get section based access working, i've create three tabs in an excel book to test this
User_Data
| USERID | USERNAME | ACCESS |
| domain\userid1 | David | USER |
Role_Mapping
| OUC | USERID |
| TA1 | domain\userid1 |
| TA2 | domain\userid1 |
(replaced with the correct windows domain and user id's that we use for authentication)
Vuln_Data
| OUC | APPID | APPNAME | VCAT | VSTATUS |
| TA1 | APPID1 | TESTAPP1 | A | Open |
| TA1 | APPID2 | TESTAPP2 | A | Open |
| TA1 | APPID3 | TESTAPP3 | A | Closed |
| TA1 | APPID4 | TESTAPP4 | A | Open |
| TA2 | APPID5 | TESTAPP5 | A | Open |
| TA3 | APPID6 | TESTAPP6 | A | Open |
| TA4 | APPID7 | TESTAPP7 | A | Open |
| TA5 | APPID8 | TESTAPP8 | A | Closed |
| TA5 | APPID9 | TESTAPP9 | A | Open |
In effect each user will be mapped to a list of ouc's they can access. Those ouc's are then mapped to the data, so if a user is mapped to an ouc, they should then only be able to see the data rows that match the same ouc.
My data load section looks like this
[IdentityRole]:
LOAD
[USERID],
[USERNAME],
[ACCESS]
FROM [lib://AttachedFiles/Qlik_V_Data_Test.xlsx]
(ooxml, embedded labels, table is User_Data);
[IdentityItem]:
LOAD
[OUC],
[USERID]
FROM [lib://AttachedFiles/Qlik_V_Data_Test.xlsx]
(ooxml, embedded labels, table is Role_Mapping);
[Vuln_Data]:
LOAD
[OUC],
[APPID],
[APPNAME],
[VCAT],
[VSTATUS]
FROM [lib://AttachedFiles/Qlik_V_Data_Test.xlsx]
(ooxml, embedded labels, table is Vuln_Data);
Is this the correct way to assemble user access, because despite my user id only be mapped to ouc 1 and 2 i seem able to a see all data ?
