Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomer1984
Contributor III
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
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
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
Contributor III
Author

i tried. didnt work

tomer1984
Contributor III
Contributor III
Author

i am looking  for a simple solution using the section access

agigliotti
Partner - Champion
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
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
Partner - Champion

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

MK9885
Master II
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 *.