
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,*
]

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i tried. didnt work

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i am looking for a simple solution using the section access


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i suggest you to take a look at working with SA in Qliksense qmc
there you'll find what you are looking for.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, security table is where you do your dynamic data reduction in section application.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 *.

- « Previous Replies
-
- 1
- 2
- Next Replies »