topic Re: Section Access - Admin Access problem in QlikView

Section Access - Admin Access problem

prabhu0505 — Sat, 12 Apr 2014 05:25:02 GMT

Hi All,

We are running an application for almost 2 years, all of a sudden for Admin privileged account no data is getting displayed.

Background:

Reading User table from a DB.

Service account is added to refresh the dashboard.

10 Admin users should see all the data

50 Users have restricted data

Now the situation:

50 Users can see their restricted data

But 10 Admin users couldn't see any data from same file

* is used for Admin records.

Thanks in Advance..

Re: Section Access - Admin Access problem

maxgro — Sat, 12 Apr 2014 05:48:46 GMT

2 things that may be can help you

- on a server documents are accessed with user rights

- * is for all listed values, not for all values of the field

Re: Section Access - Admin Access problem

prabhu0505 — Sat, 12 Apr 2014 06:30:51 GMT

Thanks for your response..

I agree on your second point.

But your first point is little confusing to me. Do you mean Admin privilege has nothing to do with Server documents?

Re: Section Access - Admin Access problem

maxgro — Sat, 12 Apr 2014 06:49:35 GMT

with Admin privilege are you talking about ACCESS field in section access section?

this is from qlikview online help

Note!
ADMIN rights are only relevant for local documents! Documents opened on a Server are always accessed with USER rights.

and this from pdf attached

ACCESS

A field that defines what access the corresponding user should have and is a required

field for all section access solutions.

There are two access levels in Section Access, “ADMIN” and “USER”. The ADMIN

controls what the USER can see and do in the QlikView document. An individual with

ADMIN privileges can change everything in the document.

(A user opening a document via QlikView (Open in Server), Plugin, Java or Ajax client

will always have USER status, regardless of the definition in ACCESS).

Re: Section Access - Admin Access problem

arsal_90 — Sat, 12 Apr 2014 06:53:50 GMT

please put this line after section application and before secuity matrix.

star is *;

In my point what is it qlikview sometimes not read *.

Re: Section Access - Admin Access problem

prabhu0505 — Sat, 12 Apr 2014 23:40:18 GMT

Hi Ashraf,

I tried below but it's not working.

Start is *;

Section Access;

Section_User_Table Load;

Section Application;

Thanks..

Re: Section Access - Admin Access problem

arsal_90 — Sun, 13 Apr 2014 01:50:42 GMT

Section Access;

LOAD upper(ACCESS) as ACCESS,

upper(USERID) as USERID,

upper(GROUP) as GROUP

FROM

[Jubilee Insurance Dashboard Security.xls]

(biff, embedded labels, table is [Sheet1$]);

Section Application;

star is *;

[Security Rights]:

LOAD GROUP,

[Retail Performance],

DSF,

Banca,

Priority,

Expenses,

Analysis,

Persistency,

DISTRIB_SYS,

Bank as Bank_Access

FROM

[Jubilee Insurance Dashboard Security.xls]

(biff, embedded labels, table is [Sheet2$]);

Re: Section Access - Admin Access problem

arsal_90 — Sun, 13 Apr 2014 01:53:06 GMT

And Also do Some workaround please make a file where u not assign * to admin u individually assign every thing that u want then check what it do.