topic Re: Section access not working in QlikView

Section access not working

zagzebski — Sun, 13 Apr 2014 00:22:30 GMT

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

Re: Section access not working

fkeuroglian — Sun, 13 Apr 2014 01:22:11 GMT

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

then you active the this?

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

Re: Section access not working

zagzebski — Sun, 13 Apr 2014 02:09:01 GMT

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?

Re: Section access not working

fkeuroglian — Sun, 13 Apr 2014 02:13:14 GMT

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?

Re: Section access not working

zagzebski — Sun, 13 Apr 2014 02:49:41 GMT

Yep - same code, same settings.

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

Re: Section access not working

fkeuroglian — Sun, 13 Apr 2014 02:53:28 GMT

It is rare

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

Re: Section access not working

zagzebski — Sun, 13 Apr 2014 03:07:06 GMT

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

Re: Section access not working

Tue, 15 Apr 2014 06:51:49 GMT

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.

Re: Section access not working

heimo_ernst_wei — Tue, 15 Apr 2014 08:37:11 GMT

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

Re: Section access not working

zagzebski — Tue, 15 Apr 2014 13:45:04 GMT

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

Re: Section access not working

Colin-Albert — Tue, 15 Apr 2014 13:51:09 GMT

To restrict access based on the Dept field using Section Access, the field name must be uppercase.

Try renaming Dept to DEPT in the Section access table and your data tables

Re: Section access not working

heimo_ernst_wei — Tue, 15 Apr 2014 13:55:47 GMT

Thank you!

How do you define "empty string"?

a semicolon at the end in line 3

Load * INLINE

[ACCESS, USERID, PASSWORD, DEPT

ADMIN, ADMIN, ADMIN,

USER, USER1, USER1, D

];

AND: you need '[' before ACCESS in line 2!!

AND: ALL in UPPER cases (see above)

Re: Section access not working

Tue, 15 Apr 2014 14:10:47 GMT

Something like this:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, BU, NTNAME

ADMIN, A, A, '', *

...

];