topic Re: Section access : how it works ? in QlikView

Section access : how it works ?

Anonymous — Wed, 26 Jun 2013 22:30:12 GMT

Dear all,

is there a man who can explain to me how hell section access works ?

I've a section access as follows:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, FIELD1, FIELD2

ADMIN, ADMQLIKVIEW, ADMQLIKVIEW,

USER, USER1, USER1, USA, USA

];

Well, working with desktop version, everything is correct: the ADMQLIKVIEW user has the vision of all data and the user the USA only.

By browser, things change: I can't access the document as ADMQLIKVIEW, only as USER1.

I also tried in this way:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, FIELD1, FIELD2

ADMIN, MYSERVER\QLIKVIEW,

USER, MYSERVER\USER1, USA, USA

];

In this case, the admin doesn't have access to the document; the user has access to the document with the right information.

How can I set an ADMIN user who can have all the data available ?

Is there a difference between section access for desktop version and for server/browser ?

What I0m doing wrong ?

Help plese , I'm becoming crazy

Re: Section access : how it works ?

Thu, 27 Jun 2013 04:05:03 GMT

Your section access script is perfect.

For all data access you have to mention as '*' (With out quotes)

Hope it will help..

Regards,

Karthik

Re: Section access : how it works ?

Thu, 27 Jun 2013 05:01:48 GMT

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, FIELD1, FIELD2

ADMIN, ADMQLIKVIEW, ADMQLIKVIEW, * , *

USER, USER1, USER1, USA, USA

];

Hope it will help u..

regards-Bika

Re: Section access : how it works ?

Anonymous — Thu, 27 Jun 2013 11:43:47 GMT

Hi,

thanks for your replays. What I know is that "*" means "all the listed values" and not "all the values"

Tthere are two scenarios:

- using server with access point

- using a local version

SERVER - ACCESS POINT case

ADMIN, ADMIN, ADMIN, *

USER, USER1, USER1, USA,

USER, USER2, USER2, ITALY

In this case , ADMIN will be allowed to see all the information concerning USA and ITALY, but not the whole data set. ADMIN user, will not be able to see GERMANY information; if you need it , you must add a new line in section access like

ADMIN, ADMIN, ADMIN, GERMANY

If I don't insert "star" for ADMIN, ADMIN will not be able to open the document.

LOCAL VERSION

Moreover, I noted that working with a local client, using SA as follows:

ADMIN, ADMIN, ADMIN,

USER, USER1, USER1, USA,

USER, USER2, USER2, ITALY

ADMIN user is allowed to see everything.

In short terms, the problem is on the server version: in order to see the whole data, it's necessary to list all the values for ADMIN user. I'm sure I'm making somethig wrong, because it seems a bit odd way to manage users permissions.

Any suggestion si appreceated

Thanks in advance

stefan