Section access not working

[zagzebski]

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

[fkeuroglian]

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]

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]

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]

Yep - same code, same settings.

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

[fkeuroglian]

It is rare

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

[zagzebski]

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

[#8]

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]

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]

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