Section Access is not working for a user

cansu — Mon, 03 Jul 2023 17:20:28 GMT

Hello,

I've setup a section access for all the users based on username, it's not working only for a person. I've check the username in the directory. It looks same an works for other people. Only for one employee, this method is not working and we are trying to understand the reason. Our section access script is below:

Concatenate(SectionAccessTable)

LOAD

'USER' AS ACCESS,

'WSC\'&KEEPCHAR(UPPER(Left([FIRSTNAME],1)&[LASTNAME]),'ABCDEFGHIJKLMNOPQRSTUVWXYZ') AS USERID,

UPPER(Left([FIRSTNAME],1)&[LASTNAME]) AS EMPLOYEE

;

SELECT

"FIRSTNAME",

"LASTNAME"

FROM "PK_DB"."TALEND_SCHEMA"."DIM_TECHNICIAN" WHERE ACTIVATED = 'T';

Section Application;

Re: Section Access is not working for a user

marcus_sommer — Tue, 04 Jul 2023 10:29:40 GMT

Equally looking values mustn't be identically. I think I would check the length and each char from both sides. Maybe with something like:

load Field, len(Field) as Len, ord(mid(Field, iterno(), 1)) as CharNumber, mid(Field, iterno(), 1) as Char,
iterno() as Iterno, rowno() as Rowno, recno() as RecNo
from Source while iterno() <= len(Field);

topic Section Access is not working for a user in Management & Governance

Section Access is not working for a user

Re: Section Access is not working for a user