topic Section Access User in QlikView

Section Access User

Judicael — Sat, 16 Nov 2024 02:36:15 GMT

Hello,

I create a section access :

STAR IS *;

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, REDUCTION
ADMIN, enterprise@CLIENT_AAA, *
ADMIN, LOCALMACHNIE\enterprise, *
ADMIN, LOCALMACHNIE\qservice, *
ADMIN, LOCALMACHNIE\enterprise, *
ADMIN, INTERNAL\SA_SCHEDULER, *
ADMIN, CUSTOM\demo_apps, *
];

SECTION APPLICATION;

LOAD
NTNAME,
VALIDATOR,
QUALIFICATOR,
GESTIONNARY
FROM $(vFolderQvd)TAB_PROFILES_USERS_FINALE.qvd (qvd);

I create an account demo_apps on the DSC >> Custom Directory

When I reload the app with section access I would to see in the NTNAME the user who log in to the WebAccess but I only see qservice (service account).

What is incomplete ?

Re: Section Access User

Miguel_Angel_Baeyens — Thu, 29 Aug 2019 13:07:50 GMT

Is this QlikView or Qlik Sense? SA_SCHEDULER only exists for Qlik Sense.

Also, in Qlik Sense you use USERID instead of NTNAME.

Additionally, NTNAME is a special field name in the section access for QlikView, which is not exposed anywhere in the data model, if you want to see it, make sure the REDUCTION field in the section access table has a counterpart in the section application of the script, or simply duplicate it with a different name.

Re: Section Access User

Judicael — Thu, 29 Aug 2019 13:08:51 GMT

QlikView

Re: Section Access User

Miguel_Angel_Baeyens — Thu, 29 Aug 2019 13:14:26 GMT

Then make sure you have in the section access table REDUCTION field all possible values listed to be visible in the data model.

"*" in the section access table means "all values listed in the section access table" and not "all the values to be loaded in the data model".

You only see the service account because it's the only account which was left after the reload.

And again, if there is not a 1 to 1 correspondence between the user name and the reduction field value, you will have to duplicate the NTNAME field in the section access table too.

Re: Section Access User

Judicael — Thu, 29 Aug 2019 13:15:13 GMT

I am loggin with demo_oryga but I get the user QSERVICE (NTNAME)

I would like to catch osuser_name

Re: Section Access User

Miguel_Angel_Baeyens — Thu, 29 Aug 2019 13:17:09 GMT

Yes, make sure the reduction field in the section access table is properly populated, and duplicate the NTNAME field in the section access table.