Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Shivam_Sahu
Contributor III
Contributor III

Error : Access is Denied(Qlik Sense Section Access)

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$;

 

 

1 Reply
vunguyenq89
Creator III
Creator III

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