Section Access

[jornk]

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
];
*/

[abhijitnalekar · Accepted solution]

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;

[jornk]

Thank you!

I don't understand why, but it works 😄

[anat]

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