Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Anyone faced the below scenario while implementing the Section Access.
In the below script, We have provided the Same Access to USER1, USER2 and USER4.
It is working for USER1 and USER2. But for USER4 show all the data instead of ORG ->1000
I have tested exact below scenario with Multiple users.
Not properly working for some users. Instead of restriction, It shows all the data.
SECTION ACCESS ;
LOAD
ZQVACCESS as ACCESS,
UPPER(ZQVNTNAME) as NTNAME,
ORG;
LOAD * INLINE [
ZQVACCESS, ZQVNTNAME, ORG
ADMIN,DOMAIN\SETTU, *
USER, DOMAIN\USER1, 1000
USER, DOMAIN\USER2, 2000
USER, DOMAIN\USER3, 1000
USER, DOMAIN\USER4, 1000
];
SECTION APPLICATION;
STAR IS *;
ORGTable:
LOAD * INLINE [
ORG
1000
2000
3000
];
Qlikview Version : 12.10 SR7
Let me know, if you need any further information.
Edited : ORG Names
Hi Settu,
you said: "See my exact sample script and output."
But the output does not match the script.
Nowhere you do define the values 5000 and 6000 for the field ORG. ???
Hidden Script?
- Christian
Did you do a last reload on your server machine (where the document is to be hosted an published in the AccessPoint)? In my experience, documents that are reloaded on a developer machine and then placed as-is on the server often caused weird authorisation issues. Especially if domains are different...
On second thoughts, you are using "Strict exclusion" in your document. Which should get you an "Access Denied" if there was something wrong with the Link field values. Did you try to access your document as a user that is not listed in Section Access?
BTW what is the version of QV Desktop? And of QV Server?
Hi All,
We found the solution. Got the response from our Admin team, There is an issue with our AD Group, and they renamed that AD group. Now it is working fine.
Thank you All !!
cool that's what I suspected earlier good you got the issue