section access not working

[wanyunyang]

I'm adding a new user to two Dashboards section access, but only one works, I have no idea why.

In the succeeded Dashboard, my script is like:

section access;

LOAD * inline

[ACCESS, USERID,REDUCTION

......

USER, 807037-BI01\operationsuser, DIRECTOR

......

];

section application;

In the failed one, my script is like:

Section Access;

LOAD * inline [

ACCESS, USERID,"Job Title",JobTitleDesc, REDUCTION

......

ADMIN, 807037-BI01\operationsuser,'ADMIN','ADMIN',*

......

];

Section Application;

I'm not able to share more data or the sample based on company's policy. Is there anything in the script doesn't seem right?

Any advice helps! Thanks in advance!

[Quy_Nguyen · Accepted solution]

May be your field name in section access is the cause.

Ref:

As the same internal logic that is the hallmark of Qlik Sense is also used in the access section, the security fields can be put in different tables. All the fields listed in LOAD or SELECT statements in the section access must be written in UPPER CASE. Convert any field name containing lower case letters in the database to upper case using the Upper function before reading the field by the LOAD or SELECT statement.

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/Security/manage-securit...