Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
luciancotea
Valued Contributor

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.

10 Replies
aaroncouran
Contributor III

Re: Section Access

did you reload the document?

sureshbaabu
Contributor III

Re: Section Access

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

Thanks

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

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

mov
Esteemed Contributor III

Re: Section Access

Maybe you have "prohibit binary load" checked?

luciancotea
Valued Contributor

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.

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.

mov
Esteemed Contributor 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.)

Not applicable

Re: Section Access

Can we impose section access on ADMIN as well??

Community Browser