topic Simulation of a user login in QlikView

Simulation of a user login

fredericvillemi — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

i'm using QV Server 10 R4 and the Active Directory authentification.

I have some problems with users which cannot see some secured documents.

Is it possible, as administrator, to simulate an access on AccessPoint and on documents with their AD credentials ?

Thanks

Simulation of a user login

Miguel_Angel_Baeyens — Tue, 10 Jan 2012 10:19:33 GMT

Hi Frédéric,

Since authentication is done by the AD, you cannot connect see their data unless you know their username and passwords.

But what you do can do is to set in section access the USERID and PASSWORD instead of NTNAME with the same REDUCTION field as thay would have. This will work not only for information reduction (called authorization) but for permissions (go to the Settings menu in QlikView, Document Properties, Server tab and click "Filter AccessPoint Document List Based On Section Access").

Anyway, if you need to check whether NTFS permissions are working fine to use the documents, you will need to use their credentials in any case.

Hope that helps.

Miguel

Simulation of a user login

fredericvillemi — Tue, 10 Jan 2012 10:27:11 GMT

Thanks for your answer Miguel :

can you confirm me the type of section access i can use ?

ADD LOAD * INLINE [

ACCESS, NTNAME, USERID, PASSWORD, TYPEACCESS

USER, AD\XXXX, , , TYPE0

USER, , XXXX, PASSWORDXXXX, TYPE0

];

Should that work ??

Re: Simulation of a user login

Miguel_Angel_Baeyens — Tue, 10 Jan 2012 10:52:51 GMT

Hi,

Use "*" instead of blanks in all fields, just in case Make sure you back up your file before changing and reloading section access, in case you lock yourself out. (Or uncheck the "Strict exclusion" un the Settings, Document Properties, Opening tab). This example works. If the accessing user is neither DOMAIN\USER1 nor DOMAIN\USER2 it will prompt for user and password. If User1 or User2 are entered, with their corresponding passwords, they will be granted access.

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, USERID, PASSWORD, TYPE
USER, DOMAIN\USER1, *, *, 1111
USER, *, USER1, USER1, 1111
USER, DOMAIN\USER2, *, *, 2222
USER, *, USER2, USER2, 2222
];
SECTION APPLICATION;
DATA:
LOAD * INLINE [
TYPE, VALUE
1111, AAAA
2222, BBBB
];

Hope that gives you the idea

Miguel