topic Re: Section Access ? in QlikView

Section Access ?

Nagaraju_KCS — Tue, 16 Jun 2015 05:25:24 GMT

Hi All,

Suppose i have this script.

Section Access;

SATABLE:
LOAD
ACCESS,
NTNAME,
SAUSER
FROM
AppConfig.xlsx
(ooxml, embedded labels, table is App1);

Section Application;

Here, What is difference Section Access and Section Application ??

Thanks in Advance....

Re: Section Access ?

prabhas277 — Tue, 16 Jun 2015 05:32:22 GMT

HI,

Section Access: Its means Building the security for data

Section Application: Its means Allowing the user what to see and what not to see..

Re: Section Access ?

avinashelite — Tue, 16 Jun 2015 06:07:32 GMT

Section Access : Is the part where you will define the list of user who have access for this documents , it acts as the gate way to access the document.

Section Application: This part code define's , based on the user login , which data need to be shown for that user and what data access he has. So the login user will able to see only that limited set of data.

eg:

Section Access;

ACCESS,NTNAME

ADMIN,ADMIN,

USER,A

USER,B

Section Application;

NTNAME,Region

ADMIN,*

A,India

B,USA

in the above eg , we have give access for 3 users admin,A and B . Apart from this the other user will not have access for the document. This is access part.

in section application we have assigned A with India so A can have access only data related to region A , similarly B can see only the data related to USA

Hope this helps you

Re: Section Access ?

Tue, 16 Jun 2015 06:12:09 GMT

Section Access: It will tell you which user can access the dashboard or u r data

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, USER01, 123

USER, USER02, 123

USER, USER03, 123

];

with the help of the userid and password the users can login

section Application: The log in user can see the data of an application up to some level.

Section Application;

LOAD * Inline [

USERID,JOB

USER01,ANALYST

USER01,CLERK

USER02,SALESMAN

USER02,CLERK

USER03,SALLESMAN

];

here job is filter if the user01 login with his password he can see out of 3 he will see 2(analyst and cleark)

Hope this will help you

thank you.