Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tomer1984
Contributor III

QlikSense section access- User \ ADMIN

hi

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

section access;

LOAD * INLINE [

ACCESS,USERID,REGION_NO

USER,NIMROD\moran,4

ADMIN,QLIK-SENSE\ADMINISTRATOR,*

];

Thanks in advance

Tomer Biran




12 Replies
YoussefBelloum
Champion

Hi,

maybe try to upper your USERID field..

SECTION_ACCESS;

LOAD ACCESS, UPPER(USERID) as USERID, REGION_NO INLINE [

ACCESS,USERID,REGION_NO

USER,NIMROD\moran,4

ADMIN,QLIK-SENSE\ADMINISTRATOR,*

]

agigliotti
Partner - Champion

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.

tomer1984
Contributor III
Author

i tried. didnt work

tomer1984
Contributor III
Author

i am looking  for a simple solution using the section access

agigliotti
Partner - Champion

i suggest you to take a look at working with SA in Qliksense qmc

there you'll find what you are looking for.

tomer1984
Contributor III
Author

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 .

agigliotti
Partner - Champion

No, security table is where you do your dynamic data reduction in section application.

MK9885
Master II

It should not matter if the name is USER or ADMIN

I do not know why it is such a big deal?

Section access;

Star is *;

LOAD * INLINE [

    ACCESS, USERID, REGION_NO

    USER, INTERNAL\sa_scheduler, *

    USER,NIMROD\moran,4

    USER1,ABC_BBC\moran,5

    USER2, CDC_BDC\moran,*

];

Section Application;

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 *.