Discussion Board for collaboration on QlikView Security and Governance.
I am trying the section access on my qlikview document and I have a hidden script as below:
LOAD * INLINE [
ACCESS, USERID, PASSWORD
USER, JDOE, JDOE
USER, JYER, JYER
USER, ANU, ANU
USERID , BUSINESS_UNIT
And have enabled the '
Check the Initial Data Reduction Based on section Access
Strict Exclusion' in the Document Settings
But when I open the document , it doesnt prompt me for a userid and PAssword instead it just opens the documents with all the data.
What needs to be done?
Go to Solution.
You inherit the security from the other qvw and it is overwriting yours. You have to move the binary load before Section Access.
did you reload the document?
your script should work. Please reload -> Save the document-> re-open it again.
I did a reload however I have a binary Load statement within my script .It is giving me the following error...
Maybe you have "prohibit binary load" checked?
No I have not done that... I was aoble t fix it by moving the binary load before the Section Access. Now it works fine.
Only one binary statement is allowed in the script and it can only be put as the first statement of a script
(I thought you had "prohibit binary" in the source file, which is common if you have section access there.)
Can we impose section access on ADMIN as well??