Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
shantanu73
Creator II
Creator II

Step required for implementation Section Access

Hello Forums/Friends,

Following Section Access script is implemented for Data Security. As per the script if User login with ADMIN user

he should able to see all records. And If user login without ADMIN user then that user should able to see related records.

But script is not working as per requirments.

SECTION Access;LOAD * Inline [
ACCESS,USERID,PASSWORD,REDUCTION
ADMIN,ADMIN,ADMIN,*
ADMIN,ADMIN1,ADMIN1,*

USER,USER1,USER1,2
USER,USER2,USER2,3
]
;
SECTION Application;star is *;LOAD * Inline [
REDUCTION,DEPARTMENTID
1,1Computer
2,2Mouse
3,3Keyboard
1,4Harddisk
1,5MousePad
]
;

Can anybody tell that whether the script is ok. And if it is ok whether anything has to be tick in the propertise.

Thanks in Advance

Shantanu

4 Replies
Anonymous
Not applicable

Hi Shantanu,

Keep in mind that all server connections are considered USER even though the user is listed with ADMIN access in section access.

Also, the * indicates all values in the field that have been listed (in this example 2 & 3).

Anonymous
Not applicable

Hi, your script is ok. You need to check the Initial Data Reduction Based on Section Access on the Opening Tab of the Document Properties. Also practial to uncheck the Remember Login Credentials Until Exit in your User Preferences. Regards, Sander

shantanu73
Creator II
Creator II
Author

Hello Johannes,

In the script the user ADMIN1 should be given as 1, But while copy paste I mistakely putted * instead of 1.

The script should be for recored number 2  as follows:

ADMIN,ADMIN1,ADMIN1,1

Thanks for giving suggession. However it is done. There is parameter which has to be tick in

Document Setting->Opening->Intital Data Reduction Based on Section Access.

Thanks

Shantanu

shantanu73
Creator II
Creator II
Author

Hello Sander,

Thank for response. But it is done.

Thank

Shantanu