Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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