topic Re: Section access issue in Qlik Sense in App Development

Section access issue in Qlik Sense

nakuldev — Fri, 07 May 2021 11:44:30 GMT

Hi All,

After reloading the section access script, I am getting the following error, "Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script."

I already added my details, however, QS is showing same error.

Below is the section access I added:

Section Access;

SECURITY:
LOAD * inline [
ACCESS, USERID, RESTRICTION
USER, DOMAIN\F12345D, *
USER, INTERNAL\SA_SCHEDULER, *
];

Concatenate(SECURITY)
LOAD
Upper(trim("Access")) as ACCESS,
Upper(trim("UserID")) as USERID,
Upper(trim(Region)) as RESTRICTION
FROM [lib://AttachedFiles/ User List.xlsx]
(ooxml, embedded labels, table is [SECURITY]);

Star is '*';

Section Application;

Thanks

Nakul

Re: Section access issue in Qlik Sense

JuanGerardo — Fri, 07 May 2021 14:20:44 GMT

Hi @nakuldev, add your user with ADMIN role to be able to open the script:

Section Access;

SECURITY:
LOAD * inline [
ACCESS, USERID, RESTRICTION
ADMIN, DOMAIN\F12345D, *
USER, INTERNAL\SA_SCHEDULER, *
];

Re: Section access issue in Qlik Sense

nakuldev — Sat, 08 May 2021 08:11:37 GMT

Hi Juan,

Initially I tried my user access with ADMIN only, however few suggested to use USER,so I changed it.

However, the issue still remains.

Thanks

Nakul

Re: Section access issue in Qlik Sense

JuanGerardo — Sun, 09 May 2021 12:26:38 GMT

Maybe the RESTRICTION field is not well implemented, for example, is also using uppercase in your fact data?

If you comment your section access (lines in bold), can you select one user from SECURITY table (not using *) and see data?

//Section Access;

SECURITY:
LOAD * inline [
ACCESS, USERID, RESTRICTION
USER, DOMAIN\F12345D, *
USER, INTERNAL\SA_SCHEDULER, *
];

//Star is '*';

//Section Application;

Re: Section access issue in Qlik Sense

JuanGerardo — Wed, 12 May 2021 12:02:24 GMT

BTW, the INTERNAL\SA_SCHEDULER user should also be added as ADMIN. Have you tried that?

Re: Section access issue in Qlik Sense

nakuldev — Fri, 14 May 2021 05:42:41 GMT

Hi Juan,

It's resolved now. The issue was with Domain, client provided me with new domain which resolved the issue.

Thanks

Nakul