Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

Using Window's Authentication for Section Access

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

7 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

amars
Specialist
Specialist
Author

Thank's Oleg

Not applicable

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

Not applicable

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

Not applicable

where I find the table called userinfo?

Is the domain name the field of the table?

Not applicable

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

Not applicable

thank you so much!