topic Section Access in QlikView

Section Access

Thu, 30 Dec 2010 01:16:59 GMT

HI All,

Is it possible to implement the section access without the User ID and Password and just by using the fields

ACCESS,

NTNAME,

NTDOMAINSID and REGION.

Regards,

pover — Thu, 30 Dec 2010 02:13:44 GMT

Yes. NTNAME is your user and the password is handled by windows. This is actually the best way to do section access.

Just make sure you put the SID of the Domain in the column NTDOMAINSID and not just the name of the domain.

Regards.

Mon, 03 Jan 2011 22:57:38 GMT

It doesn't work out. It seems like the user id is mandatory.

Can you please attach your .qvw if it works for you?

Thanks,

VJ.

Tue, 04 Jan 2011 00:49:16 GMT

If he sent you an example file with functioning section access using NTNAME, you wouldn't be able to open it. 😛

I've found the NTNAME section access parameter to be a little picky.

1) take off all of the other bits, like domain SID and region, and deal with all of that after you get ntname working.

2) disable section access completely

3) open the document and create a text box, with a formula: =osuser()

4) note EXACTLY what appears in the text box. Case sensitive.

5) put EXACTLY this value into the NTNAME portion of section access

6) give it a shot.