Section Access only working for users with RootAdmin privileges - QS

[gcharlesworth]

Hi all -

Looking for some quick insight on a small issue I'm having. While testing a basic Section Access script for an application with a small sample of internal users, I noticed that users without RootAdmin roles (given in the QMC) were denied from the application even though they were hard-coded into the Section Access script.

I verified my hypothesis by adding three fellow developers to the Section Access script (all with RootAdmin privileges) and three normal end-users from the business. The former three were able to pass and the data reduced correctly, while the latter three were denied access. I then gave a RootAdmin role to one business user and re-tested; he was able to pass and the data reduced accordingly.

Any ideas on what's going on here?

[PabloTrevisan]

Hi Gary, in cases with Data Reduction use this format....

Could you show me your script ?

EXAMPLE:

Section Access;

LOAD * inline [
  ACCESS, USERID, REDUCTION
  ADMIN, DOMAIN\USER1, USER1
  ADMIN, DOMAIN\USER2, USER2
  USER,  DOMAIN\USER3, USER3
  USER,  INTERNAL\SA_SCHEDULER,,,*
];

Section Application;

Star is *;

TAB:
Load * InLine [
    REDUCTION, CONTRY
    USER1, *
    USER2, *
    USER3, USA    
    SVC_SENSE, *

];

[gcharlesworth]

Pablo -

Here is my sample generator for SA qvd within my Qlikmart, and the SA implemented in the application:

[PabloTrevisan · Accepted solution]

Gary,

Adequate your script based on my example that will work correctly, detail: you will use the '*' in the Section Application, see my example above.

1. Section Access; 
2.  
3. LOAD * inline [ 
4.   ACCESS, USERID, REDUCTION 
5.   ADMIN, TXT\GARY, GARY
6.   ADMIN, TXT\MARIE, MARIE 
7.   USER,  TXT\JOHN, JOHN
8.   USER,  INTERNAL\SA_SCHEDULER,,,* 
9. ]; 
10.  
11. Section Application; 
12.  
13. Star is *; 
14.  
15. TAB: 
16. Load * InLine [ 
17.     REDUCTION, SOLD
18.     GARY, * 
19.     MARIE, 12546 
20.     JOHN, 123456
21.     SVC_SENSE, * 
22.      
23. ]; 

Note that SOLD it's a FIELD from your data model.