Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhu0505
Specialist
Specialist

Section Access - Admin Access problem

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

7 Replies
maxgro
MVP
MVP

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
Specialist
Specialist
Author

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

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
Creator III
Creator III

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
Specialist
Specialist
Author

Hi Ashraf,

I tried below but it's not working.

Start is *;

Section Access;

Section_User_Table Load;

Section Application;

Thanks..

arsal_90
Creator III
Creator III

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
Creator III
Creator III

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.