Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am trying to access a qvw on Access point which has section access implemented. I have NT authentication for the users in my section access script, which looks like below:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY
ADMIN, DOMAIN\USER1
ADMIN, DOMAIN\USER2, *
USER, DOMAIN\USER3, UK
];
Section Application;
test:
LOAD * INLINE [
Data, COUNTRY
10, IN,
20, UK
30, AU
40, CH
];
I have enabled strict exclusion in the properties. I provided username,pwd for reload in QMC (I gave user2). When i try to access with user1's login, i get an error "FAILED TO OPEN DOCUMENT, YOU DONT HAVE ACCESS TO THIS DOCUMENT".
I saw a few post and tried to do a reload and deleted .shared, .meta files. But nothing helped.
I am able to see the app with the other 2 users ( User2 and User3). Only user1 is getting this error. I want User1 to have access to all Conutry data.
Can someone plz help ?
Regards
Pooja
Try adding a comma after USER1 in your section access table.
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY
ADMIN, DOMAIN\USER1,
ADMIN, DOMAIN\USER2, *
USER, DOMAIN\USER3, UK
];
Hi Gysbert,
I added the comma but no luck.
Does USER1 have ntfs read access to the .qvw file?
I have set the authentication mode as NTFS in QMC. I am not sure how do i check if this User1 have read access to the .qvw. Can you please help ? I am not well aware of things on QMC. I guess its something to be done here. But not sure where ?
Yes, that's fine. But does that user have ntfs read privileges to the .qvw file stored on the filesystem of the server where Qlikview is installed?
Yes the user has full access to view the document. The strange thing is, when i give a * (for the data access) or a any value (IN,UK,AU or CH) for this user, the user is able to view the dashboard with respective data. Its only then I leave it blank I get this error. How do I handle the script when I have to give this User access to all the data ?
Which version of Qlikview are you using?
Have you tried setting the Star variable:
Star is _all_;
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY
ADMIN, DOMAIN\USER1, _all_
ADMIN, DOMAIN\USER2, *
USER, DOMAIN\USER3, UK
];
Section Application;
test:
LOAD * INLINE [
Data, COUNTRY
10, IN,
20, UK
30, AU
40, CH
];
QLikview desktop version 11.2 SR 13
and server version 11.2 SR 12
Hi Pooja,
the Problem is that DOMAIN\USER1 has 'BLANK' as value that he is allowed to see.
The Value 'BLANK' says, he might not see anything!
If you are only restricting on one reduction field (COUNTRY), then you should adapt your security to this:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY
ADMIN, DOMAIN\USER1,*
ADMIN, DOMAIN\USER2,
USER, DOMAIN\USER3, UK
USER,,IN
USER,,AU
USER,,CH
];
Section Application;
test:
LOAD * INLINE [
Data, COUNTRY
10, IN,
20, UK
30, AU
40, CH
];
According to this USER 1 sees all Countries, USER 2 has no Access (but may reload the application on QMC), USER3 sees UK
Regards