Qlik Sense - Section Access issue

[Julia]

Hello,

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 :

Section Access;

LOAD

    "ACCESS",

    "USERID",

    DOSSIER_CODE,

    OMIT

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.

Thanks in advance.

Julia

[Gabriel]

Hi,

The group of users are they included in the Section Access? If Yes.

Did you Upper DOSSIER_CODE field in the other table ?

You can attach anonymise data for the section access for community can help you.

[Julia]

Yes, the group of users are included in the section access. 

For the field DOSSIER_CODE it is also written with upper case in the table.

Here are some datas from my section access file.

[juliensaintmaxent3113]

hello,

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."

URL : "https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/Security/manage-security..."

try this solution and send us the result.

Bye

[Gabriel]

Hi,

Can user1 & user2 access the app?

[Quy_Nguyen]

You should upper case the field value also. Like: AD\ADMIN...

[Julia]

Hello everybody,

I verified all the fields  but it doesn't work. 

[juliensaintmaxent3113]

hi,

your script matches the one below?

SECTION Access;
//-------- Start Multiple Select Statements ------

Section Access;

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);

//-------- End Multiple Select Statements ---
section Application;

can you show us your loading script?

bye

[Julia]

Hi,

I tried what you suggested , but the access is denied.

My loading script : 

Section Access;

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);

Section Application;

[Gabriel]

Hi Julia,

Another suggestion could be to fully populate DOSSIER_CODE  with values such as 2,3 5. Remove OMIT column for testing purpose. The values for DOSSIER_CODE should be values in the column.