Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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?
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).
Hi
please put this line after section application and before secuity matrix.
star is *;
In my point what is it qlikview sometimes not read *.
Hi Ashraf,
I tried below but it's not working.
Start is *;
Section Access;
Section_User_Table Load;
Section Application;
Thanks..
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$]);
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.