section access (section application) doesn't work

FabioMartinelli — Wed, 29 Jan 2025 16:09:22 GMT

hi,
i have a problem with the section access.

After the reload the section application doesn't apply any data restition.
Users should see a set of "Company Code" but they see all companies.
the section access works: only the users in the file can access.
the section application doesn't work: all user can see all data.

where is the error?

This is the script that i wrote:

Section Access;

Security:
LOAD NAME,
SERIAL,
Upper(NTNAME) as NTNAME,
USER.EMAIL,
Upper(ACCESS) as ACCESS,
[DATAREDUCTION<GROUP1>]

FROM [lib://MYFILE.xlsx]
(ooxml, embedded labels, table is SECURITY);

Section Application;

SECLINK_SecurityLevel:
LOAD
[DATAREDUCTION<GROUP1>],
Company_Code as TR_Company_Code
FROM [lib://MYFILE.xlsx]
(ooxml, embedded labels, table is GROUP1);

in attach section access file.

Re: section access (section application) doesn't work

BrunPierre — Thu, 27 Jul 2023 16:05:06 GMT

Hi, When loading data from an external source in the SECTION ACCESS statement, it is mandatory for ALL the data to be in uppercase.

Re: section access (section application) doesn't work

FabioMartinelli — Fri, 28 Jul 2023 08:00:19 GMT

Thanks for the help. Works!

great!

topic Re: section access (section application) doesn't work in Management & Governance

section access (section application) doesn't work

Re: section access (section application) doesn't work

Re: section access (section application) doesn't work