Discussion board where members can learn more about Qlik Sense Data Connectivity.
I am attempting to use section access with Qlik Sense. I am testing against "ADMIN1", that is aRootAdmin in Qlik Sense, but also admin in the Windows server. I tried the following script in data load editor, I hit load data, quit then re-enter. Qlik says: "Access Denied".
LOAD * Inline [
LOAD * Inline[
ADMIN, ADMIN1 with
ADMIN, DOMAIN1\ADMIN1 but still "Access is Denied". Same when I try
ADMIN, * or
How can I make this simple test work?
could it be because you are using AD account vs. QS account? I see a good example in a help file:
Thanks Borin! I tried both AD and QS UDC accounts, both with RootAdmin/ContentAdmin roles. I tried assigning them USER and ADMIN. Both "Access Denied".
Yes thanks. I read the data reduction example, my example is much simpler (just section access, no data reduction yet), but still doesn't work. Thanks for help anyway. Appreciate it.
The example at the top of the thread does not work for 2 reasons.
1. There is no ADMIN value for the Access field in Qlik Sense. There is only USER.
2. You did not supply a reduction field in the Section Access table, therefore, the user logging in has no access to any data and results in an Access Denied message.
Seems like you have not added reduction field based on your last message. Make sure to add that and make sure that the reduction field is All Caps or Section Access will fail.
When I try, I agree with you that there is no ADMIN value for the Access field in Qlik Sense but in the help it says otherwise:
Am I missing something here?
In your lower table, you should include a field that links back to the section access table. Add a field like Age or Customer in the first table and provide values that should be used to reduce / limit access to specific data values. Hope this helps.
Please help me with this simple Section Access script.
ACCESS, USERID, EMPLOYER_NAME, OMIT
USER, LOCALUSERS\QVDEV, ABC,
USER, LOCALUSERS\QVDEV, XYZ,
USER, LOCALUSERS\QLIKUSER, XYZ,
The users QLIKUSER and QVDEV are successfully seeing the reduced data based on ABC and XYZ only but the user SENSE_SYSTEM and QVADMIN are not seeing all the data. Instead they also see the data reduced to ABC and XYZ. I have tried both USER or ADMIN in the ACCESS field for them but it just doesn't work. Can some one notice anything out of the ordinary here?