Section Access issue

[settu_periasamy]

Hi All,

Anyone faced the below scenario while implementing the Section Access.

In the below script, We have provided the Same Access to USER1, USER2 and USER4.

It is working for USER1 and  USER2. But for USER4 show all the data instead of ORG ->1000

I have tested exact below scenario with Multiple users. 

Not properly working for some users. Instead of restriction, It shows all the data.

SECTION ACCESS ;
LOAD
ZQVACCESS as ACCESS,
UPPER(ZQVNTNAME) as NTNAME,
ORG;

LOAD * INLINE [
ZQVACCESS, ZQVNTNAME, ORG

ADMIN,DOMAIN\SETTU, *
USER, DOMAIN\USER1, 1000
USER, DOMAIN\USER2, 2000
USER, DOMAIN\USER3, 1000
USER, DOMAIN\USER4, 1000

  ];

SECTION APPLICATION;
STAR IS *;

ORGTable:
LOAD * INLINE [
ORG
1000
2000
3000
];

Qlikview Version :  12.10 SR7

Let me know, if you need any further information.

Edited : ORG Names

[avinashelite]

Hmm then I feel you need to check your data set and access part once

[settu_periasamy]

Hi Peter,

I tried the same what you have mentioned.

See my exact sample script and output.

1. Script:

2. List Box (Removed Section Access Line and checked)

3. Out Put for Issued User (from Access Point )

4. Same Access working for the another User

Still now, i found this kind of issue for 7 User out of 100. I'm not sure why it is happening like this.

[olivierrobin]

hello

are you sure of the windows user code ?

it looks as if you didn't connect with the user you mention in your section access ....

try to display osuser()

[settu_periasamy]

Hi Olivier,

In the Text Object, I have added the OSUser().

The screen shot from Access point. I took the screen shot from two User.

[olivierrobin]

and it's exactly the on in your file ? no extra character like space, tabulation or so on ?

the domain is the same ?

[settu_periasamy]

I have checked character by character and checked with Admin team also.

Nothing is different. Even I tried to give single ORG (1000) for the user. Still i have an issue.

[olivierrobin]

did you check he has a license assigned and anonymous access disallowed ?

[avinashelite]

Settu , could you share the sample data with the exact names or similar names will see whats happening ...I worked on similar example but I didn't faced any issue and I am not able to replicate the issue also at my end

[avinashelite]

settu , I feel for few user the NTNAME is mapped in a different way ...try like this instead of the ORG add a name column and see whats the name its getting mapped in NTNAME because the OSUSER() and NTNAME might not be the same always

Hope you got my point

[settu_periasamy]

Hi Avinash,

Sure. I will send via mail.