Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

amars
Valued Contributor

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
MVP
MVP

Using Window's Authentication for Section Access

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
Valued Contributor

Using Window's Authentication for Section Access

Thank's Oleg

Not applicable

Using Window's Authentication for Section Access

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

Using Window's Authentication for Section Access

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

Using Window's Authentication for Section Access

where I find the table called userinfo?

Is the domain name the field of the table?

Not applicable

Using Window's Authentication for Section Access

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

Using Window's Authentication for Section Access

thank you so much!

Community Browser