topic Section Access doesnt work in QlikView

Section Access doesnt work

m4u — Thu, 28 Oct 2010 12:27:45 GMT

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

Section Access doesnt work

Thu, 28 Oct 2010 12:31:00 GMT

Hi,

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

Regards,

Ravi

Section Access doesnt work

sparur — Thu, 28 Oct 2010 12:34:25 GMT

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)

Section Access doesnt work

m4u — Thu, 28 Oct 2010 13:24:07 GMT

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)

Section Access doesnt work

m4u — Thu, 28 Oct 2010 13:26:41 GMT

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;

Section Access doesnt work

Anonymous — Thu, 28 Oct 2010 13:31:08 GMT

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

Section Access doesnt work

m4u — Thu, 28 Oct 2010 13:35:02 GMT

thanks, it works!

Section Access doesnt work

Anonymous — Thu, 28 Oct 2010 13:40:26 GMT

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