topic Using Window's Authentication for Section Access in QlikView

Using Window's Authentication for Section Access

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

Hi all,

I want to use the user's Windows login ID (NT) for section Access & the qlikview file should not ask for userID & Password again. What should I do ? Thank's in advance.

Regard's

Amar

Using Window's Authentication for Section Access

Oleg_Troyansky — Mon, 17 Aug 2009 17:58:06 GMT

Use NTNAME instead of USERID and do not require password (it's been already validated by Windows). In a server environment, you should disable Anonymous access to your Web site, in order to implement this function.

cheers,

Oleg

Using Window's Authentication for Section Access

amars — Mon, 17 Aug 2009 18:51:28 GMT

Thank's Oleg

Using Window's Authentication for Section Access

Tue, 18 Aug 2009 12:39:48 GMT

Hi Oleg,

I have similar issues.

I want to secure the QV file with respect to the NTNAME. What i mean here is when i am integrating my .qvw files into clients application, that time when any user is trying to log in to the application, the QV file should open only the relevant data with respect to the corresponding user login without asking him the userid and password again as the section acess in QV asks to enter.

Is this possible?

Yes i have tried with NTNAME as you said, my code is as below.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, SONATA\MAHASWETA.D
USER, SONATA\SENTHILKUMAR.N
];
Section Application;

But now when am trying to open still the same is asking to enter userid, even if am SONATA\MAHASWETA.D as userid its not accepting ,its only accepting the adminuser id . one more thing i can update you already i logged in to my pc with my NTNAME as SONATA\MAHASWETA.D. So will that be the reason, then in that case its should not ask the userid again right?

For NT security do i need to delpoy my qvw files to the server or to any application, or can test the same feature in QV desktop client also in the developer window.

Am not exactly sure ,but i want to implement this ,its very urgent for me.

Please help me out.

Thanks,

Mahasweta

Using Window's Authentication for Section Access

Tue, 18 Aug 2009 16:23:16 GMT

Hi,

Thanks a lot to all.

Yes i got the same to be worked. I have used the NTNAME as said by Oleg, so its working as its needed. Its not asking the userid and password again to the user.

The script is given as

//IMPLEMENTING NTLOGIN
Section Access;
Load
'USER' as ACCESS,
DOMAINNAME AS NTNAME,SCEN
Resident USERINFO;

Section Application;
Load SCEN Resident USERINFO;

Thanks ,

Mahasweta

Using Window's Authentication for Section Access

Wed, 02 Sep 2009 01:08:37 GMT

where I find the table called userinfo?

Is the domain name the field of the table?

Using Window's Authentication for Section Access

Wed, 02 Sep 2009 11:32:40 GMT

Hi, You can find the table userinfo from your database. I have created that table in my database, and we are supposed to get the table from our client.

Yes domainname is the feild of the table, so that according to the permitted NT users the security will be implemented.

Let me know if you have some issues.

Thanks,

Mahasweta

Using Window's Authentication for Section Access

Wed, 02 Sep 2009 19:17:22 GMT

thank you so much!