Section Access with NTUSER

[#1]

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

[prabhu0505 · Accepted solution]

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

[maxgro]

the product values in section application should be uppercase

[Mahamed_Qlik]

I have one doubt.

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

Kind advise.

[maxgro]

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.

[Mahamed_Qlik]

So you mean it should be like this :

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, PRODUCT

    ADMIN, MYUSERNAME, CHICKEN

    USER, TEST_USER, LAMB

];

Section Application;

?

[maxgro]

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

     ......