Discussion board where members can get started with Qlik Sense.
I am new at qliksense and i am trying to do section access for my users
(Data Reduction) and getting "no access" error .
I did the follow steps in order to setup my users and section access.
1.creating a stream and an app .
2. importing my user by UDC active directory .( i will explain why i didnt assigned admin role for the user later on )
3. allocating my user .
4. creating a security rule for only reading for app and stream .( in the preview all the users got R ( reading ))
So far so good
the user was able to access the app the stream and changes made didn't affect the report .
Then i configured the Data reduction
The problem occurs when writing the word "USER" on Section Access in the code if i change it to ADMIN it's working
however i dont want the user to be an ADMIN ,
I didnt assigned ADMIN role for the user so why USER doesnt work ?
is user role on "users" is mandatory ?
what is the difference in section access between USER and Admin ?
(i only need the user to be able to accsess read the app with reduced data ) .
This is my section access
LOAD * INLINE [
Thanks in advance
maybe try to upper your USERID field..
LOAD ACCESS, UPPER(USERID) as USERID, REGION_NO INLINE [
May be like this:
A person with ADMIN privileges has access to all data in the app. A person with USER privileges can only access data as defined in the security table.
i tried. didnt work
i am looking for a simple solution using the section access
i suggest you to take a look at working with SA in Qliksense qmc
there you'll find what you are looking for.
does security table mean the securtiy rules ?
i have created 2 rules
1. stream ( only read)
2 app ( only read )
if i delete the section access or writing ADMIN the user is able to enter the APP .
No, security table is where you do your dynamic data reduction in section application.
It should not matter if the name is USER or ADMIN
I do not know why it is such a big deal?
Star is *;
ACCESS, USERID, REGION_NO
USER, INTERNAL\sa_scheduler, *
sa_scheduler is your Qlik Sense Admin account which loads the document in QMC
Make sure your REGION_NO is in Upper in your Fact Table
Upper(REGION_NO) as REGION_NO and then use same field in your section application.
Star is *; will give a user access to all regions if available in SA script which will be an admin
USER2 will have access to both 4 and 5 region due to *.