Section Access

[Kat92]

Hi,

I have created an app in Qlik Sense and want to apply section access.

In specific the app is consisted of a star schema and want each user to be able to see their Team only on a table called OM that is the team dimension. I have added a part of code as per below

Section Access;
LOAD * INLINE
[ ACCESS, USERID, Team
ADMIN, EUNET\User1, *
ADMIN,EUNET\User2, *
USER,EUNET\User3, Team1

USER,EUNET\User3, Team2
USER,EUNET\User4, Team2
];

Section Application;

but still the User3 and 4 see all available data. Also, I have placed it before all the other sections in data load editor.

Could someone assist?

Thanks in advance

[PrashantSangle]

Hello,

All values & column name must be in upper case.

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/man....

Regards,

Prashant Sangle

[Kat92]

Hi,

The users are I just added examples here and not the actual users. The column name should also be in uppercase? I mean "TEAM" instead of TEAM although the tables name is not in the actual table I want to apply the restriction?