Fields in section access

To create the section access, Qlik Sense provides four fields that we can use to manage data security. The fields are:

  • ACCESS: This field defines what type of access the user should have. It could either be ADMIN or USERA person defined as ADMIN can access and see all the data in the application. A person defined as a USER can see only the data he or she is assigned to.
  • USERID: This is the string containing the Qlik Sense username. The proxy is used here to get the username, and then this username is compared to the value in the field. 
  • GROUPContains a string corresponding to a group in Qlik SenseQlik Sense will resolve the user supplied by the proxy against this group.
  • OMIT: This is used to omit or remove (logically) fields for certain users. You should have one line per field and the user you want to omit. 

One thing to take into account is that all the field names and values used in section access must be written in upper case. To avoid problems, the upper() function can be used in all the fields.

The next block of code shows a simple application secured by section access. The example does not reduce any data, but only secures access to the file: 

Section Access;
LOAD
UPPER(ACCESS) AS ACCESS,
UPPER(USERID) AS USERID
inline
[ACCESS,USERID
ADMIN, DOMAINJuan
USER, DOMAINMartin
];
Section Application;
LOAD
*
[LIB:\Myfiles/Sales.csv];
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.139.82.4