topic Single Sign On based on Window log in in QlikView

Single Sign On based on Window log in

Anonymous — Mon, 09 Mar 2015 14:13:38 GMT

Hi All

Is this possible to control all security(Document Properties -> Security) through window log in?

I do not want 'Initial Data Reduction based on Section Access'

I tried with below, but it breaks with some actual data issue
I need to assign ACCESS only so end user cant play with security without asking any userid/password

Section

Access;
LOAD If(Upper(OSUser())= 'CB\SATISHK','ADMIN', 'USER') As ACCESS;
Section Application;

I appreciate your help

Thanks

Re: Single Sign On based on Window log in

Anonymous — Mon, 09 Mar 2015 14:15:02 GMT

Please read as

Section Access;
LOAD If(Upper(OSUser())= 'CB\SATISHK','ADMIN', 'USER') As ACCESS;
Section Application;

Re: Single Sign On based on Window log in

Peter_Cammaert — Mon, 09 Mar 2015 14:30:30 GMT

Once you use Section Access, all visitors need to be identified. There is no escape from that requirement.

However, a possible solution for your case could be much simpler. Add this to your Section Access;-Section Application; script area:

Section Access;

LOAD * INLINE [

NTNAME, ACCESS

CB\SATISHK, ADMIN

*, USER

];

Section Application;

Best,

Peter

Re: Single Sign On based on Window log in

Anonymous — Mon, 09 Mar 2015 16:00:57 GMT

Hi Peter

It works, great

Thanks for your efforts