Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Section Access

I am trying the section access on my qlikview document and I have a hidden script as below:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN,ADMIN

    USER, JDOE, JDOE

    USER, JYER, JYER

    USER, ANU, ANU

];

Section Application;

LOAD * INLINE [

  USERID , BUSINESS_UNIT

  JDOE,  MPRS

  JYER,  MPT

  ANU,  MSH

  ];

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?

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Section Access

You inherit the security from the other qvw and it is overwriting yours. You have to move the binary load before Section Access.

View solution in original post

10 Replies
Highlighted
Creator III
Creator III

Re: Section Access

did you reload the document?

Highlighted
Creator III
Creator III

Re: Section Access

your script should work. Please reload -> Save the document-> re-open it again.

Thanks

Highlighted
Not applicable

Re: Section Access

I did a reload however I have a binary Load statement within my script .It is giving me the following error...

'Unknown statement

Binary d:\qlikstorage\userdocuments\data_model.qvw'..

Highlighted
Not applicable

Re: Section Access

I did a reload however I have a binary Load statement within my script .It is giving me the following error...

'Unknown statement

Binary d:\qlikstorage\userdocuments\data_model.qvw'..

Highlighted
Champion III
Champion III

Re: Section Access

Maybe you have "prohibit binary load" checked?

Highlighted
Specialist
Specialist

Re: Section Access

You inherit the security from the other qvw and it is overwriting yours. You have to move the binary load before Section Access.

View solution in original post

Highlighted
Not applicable

Re: Section Access

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.

Highlighted
Champion III
Champion III

Re: Section Access

From help:

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.)

Highlighted
Not applicable

Re: Section Access

Can we impose section access on ADMIN as well??