Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
zagzebski
Contributor

Section access not working

I am new to section access and tried to do something very simple based on what I read on a few discussions here

I put this simple code in the beginning of my script seeing if I could at least restrict the data to Dept "D" if I logged in as User1 but nothing is restricted.

Section Access;

Load * INLINE

ACCESS, USERID, PASSWORD, Dept

ADMIN, Admin, Admin

User, User1, User1, D

];

Section Application;

Thanks in advance for any help.

Steve

Tags (1)
12 Replies
fkeuroglian
Honored Contributor

Re: Section access not working

Hi, first of all try to put the userid and  the password in MAYUS

then you active the this?

  1. Go to Document Properties/ Opening and enable Initial Data Reduction Based on Section Access. Do not enable "Strict Exclusion"

please check this 2 points.

i attached an example , please see and follow al the points that explain

good luck

Sheets Security with Section Access

Fernando

zagzebski
Contributor

Re: Section access not working

Thanks for the response!

first of all not sure I understand "MAYUS"?

I work on two different companies servers. The code above worked on one but not the other. I have the "Initial Data Reduction..." selected on both. There must be something on the server? Some setting?

fkeuroglian
Honored Contributor

Re: Section access not working

Hi, Mayus is uppercase

it is the same document? in both server?

work in one of this two server but not in other?, you create it one time or do the document in each server?

zagzebski
Contributor

Re: Section access not working


Yep - same code, same settings.

I just don't get why it worksfine on one and not the other.

fkeuroglian
Honored Contributor

Re: Section access not working

It is rare

you create new documents? or copy paste each one to the other server?

zagzebski
Contributor

Re: Section access not working

I just copied and pasted the code from one to the other

Not applicable

Re: Section access not working

In order to function properly in a desktop as well as a server environment, two separate ADMIN entities must be defined: The first one is associated with an empty string (or any string that does not match data in the reduction field) and this entity (typically a Publisher machine) is used for reloading the application data, but this entity cannot open the application in a server environment. The second ADMIN entity is associated with a "*" in the Section Access part of the script and is never allowed to reload data, but is on the other hand allowed to view all data in a non-reduced state on the server as well as desktop.

heimo_ernst_wei
New Contributor III

Re: Section access not working

in your code:

Section Access;

Load * INLINE

ACCESS, USERID, PASSWORD, Dept

ADMIN, Admin, Admin

User, User1, User1, D

];

you are not assigning a Departement to the Admin. At least an empty field ist needed or a "*"

See a good introduction: Introduction to Section Access

zagzebski
Contributor

Re: Section access not working


Thank you!

How do you define "empty string"?

Load * INLINE

ACCESS, USERID, PASSWORD, Dept

ADMIN, Admin, Admin

User, User1, User1, D

];

Section Application;

How would it look in the example above?

Steve

Community Browser