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

[Colin-Albert]

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

[heimo_ernst_wei]

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)

[#4]

Something like this:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, BU, NTNAME

ADMIN, A, A, '', *

..

...

...

...

...

];