Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to use section access to allow all users to see all data but to filter it for one user.
I tried the following but then USER1 sees all data as well.
Section Access;
AUTHORIZATION:
LOAD * inline [
ACCESS, USERID, GROUP, REDUCTION
USER, DIRECTORY\USER1, *, 1004_M
USER, *, *, *
];
CONCATENATE([AUTHORIZATION])
LOAD
'ADMIN' AS ACCESS,
'INTERNAL\SA_SCHEDULER' AS USERID,
'*' as GROUP,
UPPER(REDUCTION) AS REDUCTION
Resident USERDATA_tmp;
KR
Section Access is just as a normal table within Qlik but hidden. what you can try and do to debug is disable the section access part of the script and just load in the table to see how it connect to the rest of the data model.
please remember that what data you want to reduce (have within section access) have to be connected to the datamodel/table you use the section access table on.
When i disable the section access and filter on USER1 i only see the 1004_M. So i would assume the restriction gets overruled by the USERID *, when the section access is active.