I have a stream with apps where a group of users can access to apps but when I add a section access with a load data from a txt file in the script, the access to apps is denied for this group of users except who are rootAdmin role.
Here is my section access :
FROM [lib://SectionAccess (ad_admin)/section_access.txt]
(txt, codepage is 28591, embedded labels, delimiter is '\t', msq);
Please help me figure out where I have been going wrong.
normally, each fields must be in the function upper like upper(USer) as User
this is a part of explication from the help:
"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."
I tried what you suggested , but the access is denied.
My loading script :
LOAD Upper("ACCESS") as ACCESS, Upper("USERID") as USERID, Upper(DOSSIER_CODE) as DOSSIER_CODE, Upper(OMIT) as OMIT FROM [lib://SectionAccess (ad_admin)/section_access.txt] (txt, codepage is 28591, embedded labels, delimiter is '\t', msq);