Error : Access is Denied(Qlik Sense Section Access)

Shivam_Sahu — Sat, 16 Nov 2024 19:34:29 GMT

Hi Folks,

I have below code which is for data restriction using section access in Qlik Sense.

I have published(everyone stream) this app in qlik sense hub.The issue I am facing is ,

*************************************

I am able to open application and data restriction is also working fine(I am able to see data for WEST region only)

but TID1 and TID2 users are getting access is denied error when they are opening application in hub

****************************************

Please refer to below code and help me to find the reason for above mentioned issue.

Section Access;

Load * Inline [
ACCESS,USERID,REGION
ADMIN,Domain\MYTID,WEST
ADMIN,Domain\TID1,YUKON
ADMIN,Domain\TID2,QUEBEC
];

Section Application;
Orders:
load *,
Upper(Region) as REGION
Resident Orders$ ;
Drop Table Orders$;

Re: Error : Access is Denied(Qlik Sense Section Access)

vunguyenq89 — Fri, 29 Nov 2019 09:18:58 GMT

Hi,

You can try the following:

Verify that data reduction of the Section Access table works correctly. See https://support.qlik.com/articles/000005591
Make sure UserID of users TID1 and TID2 are correct. You can do this by logging in as these users, create a new app, create a text object with the following function =OSUser() . Make sure this function returns exactly the same user id provided in the Section Access table (Domain\TID1)

Hope this helps,

BR,

Vu Nguyen