Section Access - Admin Access problem

[prabhu0505]

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..

[maxgro]

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

[prabhu0505]

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?

[maxgro]

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).

[arsal_90]

Hi

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

star is *;

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

[prabhu0505]

Hi Ashraf,

I tried below but it's not working.

Start is *;

Section Access;

Section_User_Table Load;

Section Application;

Thanks..

[arsal_90]

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$]);

[arsal_90]

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.