Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, first of all try to put the userid and the password in MAYUS
then you active the this?
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
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?
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?
Yep - same code, same settings.
I just don't get why it worksfine on one and not the other.
It is rare
you create new documents? or copy paste each one to the other server?
I just copied and pasted the code from one to the other
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.
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 "*"
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