Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Julia
Contributor
Contributor

Qlik Sense - Section Access issue

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

10 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

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
Contributor
Contributor
Author

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.

section_access.PNG

juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

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
Partner - Specialist III
Partner - Specialist III

Hi,

Can user1 & user2 access the app?

Quy_Nguyen
Specialist
Specialist

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

Hello everybody,

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

juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

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
Contributor
Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

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.