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: 
m4u
Partner - Creator II
Partner - Creator II

Section Access doesnt work

Hi all,

i need to limit records according to users,

i add this code to my load script:


Star is *;

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, CARDCODE
ADMIN, ADMIN, P, *
USER, DEMO1, P, XXXXX
];
Section Application;

i have a CARDCODE column in one of my tables.

i also checked the "intial data reduction based on section access" on the "document properties" page.

when opening the qv file it doesnt asc for any user/password and all data are displayed.

thanks

shlomo

7 Replies
Not applicable

Hi,

Can you make Upper(CARDCODE) in the script and then try the same.

Regards,

Ravi

sparur
Specialist II
Specialist II

Hello Shlomo

Are you sure that you have the same column in your application table? this Field must have the same name - CARDCODE (i.e. in Upper case)

m4u
Partner - Creator II
Partner - Creator II
Author

THANKS,

now it working fine but it taks effect only after reloading data.

1. i'm login with an admin user

2. runing reload - all data is reloaded

3. i save the file

4. now im login with a regular user - only the premited data are displayed

5. now im login agin with admin, and i see only a part of the data (like the regular user)

m4u
Partner - Creator II
Partner - Creator II
Author

i think the point is that "*" doesnt work for admin user

Star is *;

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, DELARCODE
ADMIN, ADMIN, 1, *
USER, DEALER, 1, XXXX
];
Section Application;

Anonymous
Not applicable

I'm sure it will work if you leave it blank:
ADMIN, ADMIN, 1,

m4u
Partner - Creator II
Partner - Creator II
Author

thanks, it works!

Anonymous
Not applicable

Explanation:
Star in Section Access doesn't mean "all" - it rather means "all listed in the records of the section access".