Discussion Board for collaboration on QlikView Scripting.
Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.
Not sure what is happening, when i log with ADAM, i see only JCPenney.
Can someone help me on the same.
In b/w the below things are taken care
I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.
LOAD * Inline [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM, *
USER, PETER, PETER, WALLMART
Do you have data for Wallmart in your dashboard ?
This is just a test data. I don't have data for JCPenney as well
Please try the attached and let me know. I used your data so when you login as :
Adam you will see all the data and when you login as Peter you will see only 'Wallmart'
if you want in "Security" tab you can also check "Admin Override Security"
Hope this helps.
Remove '*' and try..
Check this links hope it helps you.
Authentication and Authorization in Qlikview
Various levels of security implementation using Section Access
This is strange. * indicates all data right . any reason to remove *?
See here.. Re: Section Access "Star"
May be you can try like
Section Access; LOAD * INLINE [ ACCESS, USERID, PASSWORD, LINK ADMIN, ADAM, ADAM, * USER, PETER, PETER, WALLMART USER, USER,PASSWORD,JCPENNEY ]; Section Application; Provider: LOAD * Inline [ LINK JCPENNEY WALLMART ];
use blank as per sethu said
try like this
START is *;
STAR is *;