problem with section access

[omid5ive]

hi

i have a dashboard that multi user have access to it and it has a multi tab

each user have access to certain tab

i attached my sample

access table is something like below:|

when i login with md1\qlikview every thing is ok and i can see just sheet 1 and 2 but when i login with the other user access point redirect me to login page

* in distribute tab i set named user and add all 3 users

please help me

[omid5ive · Accepted solution]

finally i find the solution

i changed my section access like blow:

section Access;

LOAD

    'ADMIN' as ACCESS,

    Upper('Md1\'&SAMAccountFullName) as NTNAME,

    if (SubStringCount(SAMAccountFullName,'qlikview')=0,User_ID,'*') as REDUCTION_KEY;

SQL SELECT *

FROM Users;

notice:
qlickview user is a user that qlikview server service is run with it