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: 
rsdhavle
Creator II
Creator II

'NULL' in Section Access

I have few queries as we are building security model. I have my section access table as follows

NTNAMEACCESSIDPARAMETER1
USER1ADMINALLALL
USER2USERNULLALL
USER3USERNULLALL
USER4USER1234ALL

Questions:

  • User4 has access on ALL Parameter1's but not on all ID's so his access should be 'ADMIN' or 'USER'
  • USER2 and USER3 has NULL values in table for Column ID and has access on 'ALL' Parameter1's so on which ID's the user will get access on?
2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

All end-users should have role USER. Role ADMIN will only make a difference when opening your document in the QlikView Desktop. In the AcccessPoint, ever visitor will forcibly have role USER, whether ACCESS=ADMIN or not. Add an ADMIN entry for the developer, and one for the service account responsible for reloading your document on the QlikView Server.

Links for data reduction must be explicitly specified. There is no real ALL marker, except '*' which means 'every value that appears in this field'. If you create Section Access at the start of your script (for example in a Hidden Script) there is only limited data in those fields, and your security will never map to the whole of the data set.

Double links are to be avoided. They won't create circular references (ties are cut after data reduction), but they will wreak havoc in your document. Concatenate the two parameters values into a single key field, and link from there.

BTW the best technique to create the ALL list of values for each field is from the data itself. First load your entire data set, then filter out the possible values for ID and PARAMETER1, and only then create the tables and values in your Section Access;

Best,

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Sorry, I forgot: you cannot associate on real NULL values. If you still try do this,and  Strict Exclusion has been enabled, USER2 and USER3 will never get access to this document.

Peter,