Section Access - Reload fails - Access Denied

[Markbhai]

Hi All,

I think this is fairly different from similar questions on here, so let me start by saying that my Section Access is working well in terms of restricting access to the data set.

I am restricting access on the basis of org_id and have tested with multiple users and this aspect works fine. However, I have a 'reload button' on my sheet which allows the user to reload data.  This button works correctly for the Admin user, but does not work for the 'USER' user set up in Section Access.  When these users click this they get the message:

The section access script looks like this:

The users are set up in Qlik as 'Embedded Analytics User'

I am guessing at the moment that this may be a user access privaledges issue and seeking to resolve.

Thanks

Mark.

[marksouzacosta]

I see potential problems with your code:

1 - Put all your Section Access code inside the Section Access part, unless you need to expose it to the users.

2 - All column names and values must be upper case. I see this rule been ignored in Qlik Cloud, but keep everything upper case, including in your Section Application, just in case. In your example, rename org_id to ORG_ID.

3 - Admin user is loading only ORG_ID 1. Usually the ADMIN user loads everything, in your case just leave  ORG_ID it blank.

I don't see a way of users reloading your app having Section Access restrictions being applied without blocking other users. You will probably need to review your app requirements.

[Markbhai · Accepted solution]

Thanks for your reply.

It appears that what I am attempting to achieve is not available directly from within Qlik Sense and that instead we will need to use a Qlik API and develop some Java code (according to Chat GPT).

Thanks for the input.