topic Re: Problem with Section Access and NTNAME in QlikView

Problem with Section Access and NTNAME

Mon, 10 Jun 2013 09:05:27 GMT

Hello everyone,

I'm having a problem using Section Access and NTNAME on my document. In my script, I have this:

section Access;

LOAD [ACCESS],

[NTNAME],

[USUARIO],

[GROUP]

FROM

..\QVD\PermisosAuto.xlsx

(ooxml, embedded labels, table is Hoja1);

SECTION Application;

LOAD [GROUP],

Text(Station_ID) as Station_ID

FROM

..\QVD\PermisosAuto.xlsx

(ooxml, embedded labels, table is Hoja2);

And then, I have this PermisosAuto.xlsx, where I have the NTNAMEs for each user, and their groups, and another sheet where I have all the Station_ID a user should be able to see depending on his group:

ACCESS	NTNAME	USUARIO	GROUP
ADMIN	APPLUSCORP\ADMIN-QV	ADMIN-QV	1
ADMIN	APPLUSCORP\ADMIN-IOLIVA	ADMIN-IOLIVA	2
ADMIN	APPLUSCORP\PTURULL	PTURULL	3
ADMIN	APPLUSCORP\ADMIN-AGIL	ADMIN-AGIL	4
ADMIN	APPLUSCORP\ARETES	ARETES	5
ADMIN	APPLUSCORP\ACAMPINS	ACAMPINS	6
ADMIN	APPLUSCORP\ABASCUNANA	ABASCUNANA	7

GROUP	Station_ID
1	A11
1	L02
1	T02
2	B02
3	B05
3	B07
3	B08
4	B09
5	B10
6	B11
7	B12
7	B14
7	B15
7	B17

So, GROUP 1 should see A11, L02 and T02 only, GROUP 2 should only see B02, etc.

The problem I'm having is EVERYONE is entering as Group 1, and I don't know why. Everyone is getting his own OSUser (NTNAME) correctly, but they enter the document as group 1, no matter what his NTNAME is.

Could anyone help me and explain me where is the problem I'm doing in the script/excel section access?

Thanks in advance.

Re: Problem with Section Access and NTNAME

jeffmartins — Mon, 10 Jun 2013 17:22:15 GMT

Hi albert.gil,

You should check the "Initial Data Reduction Based on Section Access" box on document properties in the opening tab.

The "Strict Exclusion" box is used to prevent users not listed in section access table could access the application.

Regards

Re: Problem with Section Access and NTNAME

Tue, 11 Jun 2013 15:43:45 GMT

Yeah, it's done. And it still doesn't work. It looks like the problem is on the server. When saving this document, it works correctly. But when the publisher reloads the document and publishes it, all users are opening the document as Group 1. Maybe I'm missing something in the reload process?

Re: Problem with Section Access and NTNAME

jeffmartins — Tue, 11 Jun 2013 16:27:05 GMT

Hi albert.gil,

Have you included the user responsible for performing the task reload ?

This setting is found on QMC -> Document -> Choose your document on the tree view -> Reload tab

Regards

Re: Problem with Section Access and NTNAME

hannan_t — Fri, 29 Aug 2014 08:18:37 GMT

I was facing the same issue. You also have to add Station_ID in PermisosAuto.xlsx and you'll get it resolved.

Re: Problem with Section Access and NTNAME

salto — Fri, 29 Aug 2014 08:25:00 GMT

Hello Albert,

correct me if I am wrong but, ADMIN access overrides security. Please change the ADMIN to USER where needed:

ACCESS	NTNAME	USUARIO	GROUP
ADMIN	APPLUSCORP\ADMIN-QV	ADMIN-QV	1
USER	APPLUSCORP\ADMIN-IOLIVA	ADMIN-IOLIVA	2
USER	APPLUSCORP\PTURULL	PTURULL	3
USER	APPLUSCORP\ADMIN-AGIL	ADMIN-AGIL	4
USER	APPLUSCORP\ARETES	ARETES	5
USER	APPLUSCORP\ACAMPINS	ACAMPINS	6
USER	APPLUSCORP\ABASCUNANA	ABASCUNANA	7

Hope this helps.

Re: Problem with Section Access and NTNAME

simondachstr — Fri, 29 Aug 2014 08:30:12 GMT

I agree, ADMIN generally can see everything.

Re: Problem with Section Access and NTNAME

hannan_t — Fri, 29 Aug 2014 08:57:04 GMT

Yes, Admin can see everything