Section Access doesn't reduce data

[Peony]

Hi all. 

Request your help  with section access. There is my code below:

Table:
Load * Inline [
CostCentre
A
B
C
D
];



Section Access;
Star is *;
Access:
LOAD *  Inline [
Access,	UserID,	Password, 	CostCentre
USER,	USER,	USER,		*
ADMIN,  ADMIN,	ADMIN,		*
USER,	JOHN,	JOHN,		A
USER,	MARY,	MARY,		B
USER,	PETER,	PETER,		C
ADMIN,	SIMON,	SIMON,		A
];

Section Application;

For some reason, once I login as one of the user, let's say as JOHN, I still see all Cost Centre instead of A only. I don't understand what am I doing wrong with section access?

[Albert_Candelario]

Hello @Peony ,

Thanks for posting.

In the section access table for the fields ACCESS, USERID,...  as per the guide I always use them in capital letters and then the application would need to be reloaded again.

I assume the value of the blue square if the one for the UserID of the user who has login, so there is no need to use NTNAME or another field instead.

Apart from the capital topic, the rest seems ok as far as I could see. Maybe someone else on the Community has a further insight.

Cheers,

Albert

[Peony]

Hi @Albert_Candelario  Thank you for response.

I changed fields names into  capital letters, reloaded and unfortunately data still not reduced for any user.

As for the blue square, I use there QvUser().

[elyMalkiAcn]

[Table]:
noConcatenate
Load * Inline [
CostCentre
A
B
C
D
];

Star is *;
[Access]:
noConcatenate
LOAD *  Inline [
ACCESS,	USERID,	PASSWORD, 	CostCentre
USER,	USER,	USER,		*
ADMIN,  ADMIN,	ADMIN,		*
USER,	JOHN,	JOHN,		A
USER,	MARY,	MARY,		B
USER,	PETER,	PETER,		C
ADMIN,	SIMON,	SIMON,		A
];

Section Access;

Access_SA:
noConcatenate
load
ACCESS
,USERID
,PASSWORD
,CostCentre
resident [Access];

Section Application;
drop Table [Access];

This is possible solution on Script side

BR,

Ely

[marcus_sommer · Accepted solution]

Did you enable the section access within the document properties in tab open? And there also enabling the restrictive mode?

Beside this be careful and keep at least one copy of your application without the section access!

- Marcus

[Peony]

Hi @elyMalkiAcn Thank you for your help. Unfortunately the reason of the issue not in code, but in document settings. 

[Peony]

Hi @marcus_sommer  Indeed! My bad!😬 I haven't checked document settings before.  Thank you for the hint!