Loading fails with Section Access loaded from sql

[alci]

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

[MayilVahanan]

HI 

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/man...