Loading fails with Section Access loaded from sql

alci — Wed, 29 Jan 2025 16:57:53 GMT

Hi,

I have a problem where application reloading fails when I populate the security table from sql.

Here is a simple example. My user is MYDIRECTORY\froutier. The following script succeeds when I manually reload the application:

LIB CONNECT TO [PostgreSQL_10.0.0.10 (mydirectory_froutier)]; Section Access; [Security]: LOAD * inline [ACCESS, USERID, Conf ADMIN, MYDIRECTORY\froutier, * ]; Section Application; [Data]: LOAD * inline [Id, Value, Conf 1, 550, 1 ];

But if I load the exact same Section Access data using SQL, it fails with :

"Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script."

LIB CONNECT TO [PostgreSQL_10.0.0.10 (mydirectory_froutier)]; Section Access; [Security]: LOAD ACCESS, USERID, Conf; select 'ADMIN' as "ACCESS", 'MYDIRECTORY\froutier' as "USERID", '*' as "Conf"; Section Application; [Data]: LOAD * inline [Id, Value, Conf 1, 550, 1 ];

I think the exact same data is used, how comes the result differs ?

Any hint is appreciated 🙂

Franck

Re: Loading fails with Section Access loaded from sql

MayilVahanan — Mon, 04 Oct 2021 00:17:35 GMT

In Section access, all field must be in Upper case. Can you follow the guidelines in the below link. It may help you.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

topic Loading fails with Section Access loaded from sql in Management & Governance

Loading fails with Section Access loaded from sql

Re: Loading fails with Section Access loaded from sql