Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
amars
Specialist
Specialist

Using NTName & NT Password for section Access (Urgent)

Hi all,

I wish to use NT Name & Nt Password for section Access. The NTName & NT Password Should Pop up as it popup when we use USERID & PASSWORD.

How to do that. Thank's in advance.

Regards

Amar

1 Solution

Accepted Solutions
Bjorn_Wedbratt
Employee
Employee

Hi Amar,

You can't, simply because the password isn't stored in plain-text in AD (at least not by default) so there's no way to extract the password into Section Access. When using NTNAME two things will happen, depending on client and the way you access the document:

In stand-alone QlikView (working locally with the qvw-document), QlikView will utilize the fact that you're already authenticated against the domain/workgroup through your operating system. This will give a single-sign-on experience so you don't have to enter credentials everytime. If you want to open the file using other users credentials you neeed to run QlikView using the Run as... command. There's no fall-back if authorization fails (you don't have access to the file), asking for alternative credentials. This could be a future feature request if needed.

If you're using stand-alone QlikView or QlikView plugin, accessing a QlikView Server the same will apply. However if authorization fails, you have the option to use Alternate Identity in the Connect to Server dialog. If you do, crendentials will be sent to QlikView Server, which will impersonate the user.

If you're using Java or ZFC authentication is managed by your web server. Depending on how you configured authentication on your web server you will always be prompted (Basic Authentication) or you will have a SSO experience using Integrated Windows Authentication. Here the client (web browser) will always try to access resources anonymously. The web server will then return a 401 (unauthorized) challenging the client for credentials. If using IWA this will be silent to the end-user, unless authentication fails. Then the web browser will prompt the user for alternative credentials.

View solution in original post

5 Replies
markmccoid
Partner - Creator II
Partner - Creator II

Hi,

When using NT Name for authentication I don't believe you will see a pop up. The NT Name is passed behind the scenes to QlikView which then checks it against your security list that you loaded into Section Access.

This is how it works for us.

Mark

Not applicable

This message was posted by Mahasweta on the 18/08/2009 (sorry Mahasweta - I hope you don't mind me using your solution)

---

Hi Yiling,

I got the same through NTNAME section access.And it works for me.

You can check the same if it helps you.

The script is as below,

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

Section Application;
Load SCEN Resident USERINFO;

Here my domain name and access info is coming from the database, so which all users NTNAME is mentioned in the database, they only can open the file.

And when the allowed user tries to open the file its not asking him the userid and password again, as the same is fetched from the windows NT login.

Hope it may help you.

Thanks,

Mahasweta

amars
Specialist
Specialist
Author

Thanks both of you.

But this is not what I wanted. I want that despite taking the NTName from the machine , it should ask me for the NT Name & NT Password. (Just like UserName & PassWord)

Thanks & Regards

Amar

Bjorn_Wedbratt
Employee
Employee

Hi Amar,

You can't, simply because the password isn't stored in plain-text in AD (at least not by default) so there's no way to extract the password into Section Access. When using NTNAME two things will happen, depending on client and the way you access the document:

In stand-alone QlikView (working locally with the qvw-document), QlikView will utilize the fact that you're already authenticated against the domain/workgroup through your operating system. This will give a single-sign-on experience so you don't have to enter credentials everytime. If you want to open the file using other users credentials you neeed to run QlikView using the Run as... command. There's no fall-back if authorization fails (you don't have access to the file), asking for alternative credentials. This could be a future feature request if needed.

If you're using stand-alone QlikView or QlikView plugin, accessing a QlikView Server the same will apply. However if authorization fails, you have the option to use Alternate Identity in the Connect to Server dialog. If you do, crendentials will be sent to QlikView Server, which will impersonate the user.

If you're using Java or ZFC authentication is managed by your web server. Depending on how you configured authentication on your web server you will always be prompted (Basic Authentication) or you will have a SSO experience using Integrated Windows Authentication. Here the client (web browser) will always try to access resources anonymously. The web server will then return a 401 (unauthorized) challenging the client for credentials. If using IWA this will be silent to the end-user, unless authentication fails. Then the web browser will prompt the user for alternative credentials.

amars
Specialist
Specialist
Author

Thanks a lot Bjourne.