topic Re: Section Access with NTUSER in QlikView

Section Access with NTUSER

Mon, 02 Nov 2015 17:43:54 GMT

Hi,

I'm trying to implement section access using NTNAME rather than a username and password. I tried with a very simple example, as below, and I can't get it to work at all.

If I reload with the below script, I can see all PRODUCTS. If I change 'ADMIN' to 'USER', I get an access denied error and the document is locked. Osuser() returns MYDOMAIN\myusername. If I try replacing myusername with MYDOMAIN\myusername, I get the same behaviour.

Can anyone tell me what I'm doing wrong?

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODUCT

ADMIN, myusername, chicken

USER, test_user, lamb

];

Section Application;

LOAD * INLINE [

PRODUCT, COUNTRY, VALUE

chicken, UK, 20

chicken, Spain, 35

chicken, France, 22

chicken, US, 45

beef, UK, 23

beef, Spain, 26

beef, France, 25

beef, US, 44

lamb, UK, 66

lamb, Spain, 42

lamb, France, 32

lamb, US,102

]

Thanks in advance

Tom

Re: Section Access with NTUSER

prabhu0505 — Mon, 02 Nov 2015 18:12:45 GMT

Make NTNAME, PRODUCT field values Upper case on both the tables.

Re: Section Access with NTUSER

maxgro — Mon, 02 Nov 2015 18:23:43 GMT

the product values in section application should be uppercase

Re: Section Access with NTUSER

Mahamed_Qlik — Tue, 02 Feb 2016 11:56:28 GMT

I have one doubt.

For section access, only we need the field name is upper case rather than its value...

Kind advise.

Re: Section Access with NTUSER

maxgro — Tue, 02 Feb 2016 12:07:59 GMT

this is from QlikView help

All the fields listed in Load or Select statements in the section access must be written in UPPER CASE.

Any field name containing lower case letters in the database should be converted to upper case using the upper function.

I think field name in uppercase is a must.

Field values outside section access uppercase.

Field values in section access upper/lowercase (Qlik will convert to upper).

I usually use upper everywhere (simple) for sec acc.

Re: Section Access with NTUSER

Mahamed_Qlik — Tue, 02 Feb 2016 12:10:42 GMT

So you mean it should be like this :

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODUCT

ADMIN, MYUSERNAME, CHICKEN

USER, TEST_USER, LAMB

];

Section Application;

Re: Section Access with NTUSER

maxgro — Tue, 02 Feb 2016 12:35:34 GMT

in Section Application case must match the section access case

IMHO case of values in section access is upper (Qlik will convert to upper)

so case of values in section application must be upper or converted to upper (you have to convert if lower)

Section Application;

load

upper(PRODUCT) as PRODUCT,

.....

from

......