Section Access doesn't work Qlik Sense September 2017

[alessandro_mari]

Good morning experts,

I'm Alessandro.

I have an issues with SA. Every time i try to access the file, sense turn to me an "Access Denied" error.  USERID is equal to Sense User name.

Thanks in andvance,

Alessandro

PS the same SA works in QlikView

section access;

Accessi:

load

'USER' AS ACCESS

,upper(USERID) as USERID

,NTNAME as USER

FROM [$(pathXLS)\Nuti.xls] (biff, embedded labels, table is Restrizioni$)

where not isNull(NTNAME);

concatenate (Accessi) load

'ADMIN' as ACCESS

,upper(trim(subfield('$(RestrictionsSuperusers)', ','))) as USERID

,'*' as USER

autogenerate 1;

[Ricardo_Gerhard]

The full and correct that you want to test is this:

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION, OMIT

USER, DOMAIN\SANDRA,*,

USER, DOMAIN\OLGA,*

ADMIN, INTERNAL\SA_SCHEDULER,*,];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

Take a look, the DOMAIN or COMPUTER name must be set as the same on license allocated for both users.

Do you know if this problem isn´t happening without a Section Access? Have you checked if this users have token allocated?

[alessandro_mari]

Yeah, without SA i can open the App

[agigliotti]

could you send a printscreen with OSUser() in a sheet object without section access ?

[alessandro_mari]

All fields are already been in uppercase

[alessandro_mari · Accepted solution]

Thanks to everibody, I solved the problem.

I used the wrong "DOMAIN"; I need to use the UserDiresctory instead