section access probelm in access point

[omid5ive]

hi

i have qlik view server

i want to create document that each user can see related tab

i have a table that contain my domain users and related tab like below

User_ID	SAMAccountFullName	access
729	MD1\o.ebrahimi	a
733	MD1\qlikview	a,b,c
734	MD1\a.ghaffari	b

i create my section access script like below:

section Access;

LOAD 'ADMIN' AS ACCESS,

     upper(SAMAccountFullName) as NTNAME;

SQL SELECT *

FROM Users;

section Application;

SELECT ucase(Users.SAMAccountFullName) AS NTNAME,

access

FROM Users ;

and i set this option like below:

in this sample md1\o.ebrahimi just can see  tab 1 and md1\qlikview can see 1,2,3

with this setting in desktop mode i have no problem but in server it dose not work

[vinieme12]

create a text file with the section access script and import the same file within each app..

IF you don't want to do section access on script then work this out in QMC

[omid5ive]

i created my section access like your explain
but i have another problem

i can just login with user that have maximum of access. when i login with another user it will direct me to login page

[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