topic Re: Section Access in App Development

Section Access

jornk — Thu, 02 Dec 2021 15:20:57 GMT

Hi,

I'm a bit confused about the section access in the data load editor. In the example below I'm trying to give access to users that are connected to a specific location. But when I run the script as is, I get an error saying:

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

If I run the 'LOAD * inline' part instead, it works as expected.

Thanks in advance!

-------------------------

Section Access;

LIB CONNECT TO 'MyDataSource';

Authorization:
LOAD Access as "ACCESS",
UserID as "USERID",
LocationID as "LOCATIONID";
SELECT ua.Access,
ua.UserID,
ul.LocationID
FROM [Schema].[Table].[UserAccess] ua,
[Schema].[Table].[UserLocation] ul
WHERE ua.UserID = ul.UserID;

/*
LOAD * inline [
ACCESS, USERID, LOCATIONID
USER, MYGROUPNAME\myuserid, 1
];
*/

Re: Section Access

abhijitnalekar — Thu, 02 Dec 2021 18:22:36 GMT

Have you tried like below

LOAD upper(Access) as "ACCESS",
upper(UserID) as "USERID",
Upper(LocationID) as "LOCATIONID";
SELECT ua.Access,
ua.UserID,
ul.LocationID
FROM [Schema].[Table].[UserAccess] ua,
[Schema].[Table].[UserLocation] ul
WHERE ua.UserID = ul.UserID;

Re: Section Access

jornk — Fri, 03 Dec 2021 10:11:48 GMT

Thank you!

I don't understand why, but it works 😄

Re: Section Access

anat — Fri, 03 Dec 2021 10:19:07 GMT

Section access must requires all field names and values to be uppercase. We need to use Uppercase only left of INLINE tables, where the conversion in QlikView itself. ... When you LOAD your section access table, no matter where you are getting and from, all fields and values must be uppercase