Section Access doaesn't work.

[Judicael]

Hello,

I create a file admin user and user file:

Admin User Profile : ONLY INTERNAL ADMIN.

ACCESS;NTNAME
'ADMIN';'demo_qlikview' (account create in qmc)
'ADMIN';'HOSTNAME\jdoe'
'ADMIN';'DOMAIN_NAME\user1'
'ADMIN';'HOSTNAME\user2'
'ADMIN';'HOSTNAME\QVAdmin'
'ADMIN';'NT AUTHORITY\Authenticated Users'
'ADMIN';'AUTORITE NT\Utilisateurs authentifiés'
'ADMIN';'HOSTNAME\qservice'
'ADMIN';'INTERNAL\SA_SCHEDULER'
'USER';'user999'
'USER';'user202'

Users Profile : Users use login on an extranet composed (LASTNAME + ' ' + FIRSTNAME)

ACCESS;NTNAME
'USER';'CHRISTOPHE PAUL'
'USER';'ROY HERVE'

I create a user on QMC to access to the document for the test but when i reload the task and open document I want to see the user that I use to connect to the Web portal like demo_qlikview but I see only 'NT AUTHORITY\Authenticated Users'

I want to see demo_qlikview  as NTNAME. When I use a text object : OSUSER() I see demo_qlikview.

My script;

STAR IS *;

SECTION ACCESS;
LOAD
ACCESS,
UPPER(NTNAME) AS NTNAME,
UPPER(DPO_PROCESS_REDUCTION) AS REDUCTION
FROM $(vFolderQvd)Securite_Final.qvd(qvd);

SECTION APPLICATION;

TAB:
LOAD
NTNAME,
VALIDATOR,
EXECUTIVE,
INITATOR
FROM $(vFolderQvd)PROFILES_USERS_FINALE.qvd (qvd);

Is the 'ADMIN';'NT AUTHORITY\Authenticated Users' is needed for the reload task ?

Thanks for your help.

Regards.

[Judicael]

IS the NTERNAL\SA_SCHEDULER' is needed ?

'ADMIN';'INTERNAL\SA_SCHEDULER'

[Brett_Bleess · Accepted solution]

Cédric, below is the Help link to Section Access in case you have not reviewed things there:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

I think the issue may actually be related to the following Article post though:

Using QVD file in Section Access load

Hopefully the latter will do the trick for you.

Regards,
Brett