topic Section access not prompting for password in QlikView

Section access not prompting for password

richnorris — Mon, 26 Mar 2012 09:59:29 GMT

I have the following section access set up:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTLOGIN

ADMIN, ADMIN, ADMIN123, *

ADMIN, *, *, HBEU\HBEU-SERVER

USER, Akb, Research, *

USER, Nnr, Research, *

USER, Mrl, Research, *

USER, Sri, Research, *

USER, Hdg, Research, *

USER, Ptl, Research, *

];

Section Application;

Where HBEU\HBEU-SERVER is the name of the qlikview server account for doing scheduled reloads.

The idea is that everyone but admin can log in with the password Research, and Admin would log in with ADMIN123, and that the server can use its NT login. However in practice what happens is no one gets prompted for a password and logs in with whatever their NTLogin is.

I thought this was a pretty standard approach to section access, is there something obvious I'm doing wrong?

Thanks in advance!

Re: Section access not prompting for password

hic — Mon, 26 Mar 2012 10:13:30 GMT

The field NTLOGIN should be called NTNAME instead. And you should use upper case for all field values.

/HIC

Section access not prompting for password

richnorris — Mon, 26 Mar 2012 10:16:14 GMT

Right. Thats where I was being an idiot. Thanks!

Section access not prompting for password

hic — Mon, 26 Mar 2012 10:41:31 GMT

If such an error makes you an idiot, then we're all idiots...

HIC