Problem with Section Access and NTNAME

[#1]

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.

[jeffmartins]

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

[#3]

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?

[jeffmartins]

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

[hannan_t]

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

[salto]

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.

[simondachstr]

I agree, ADMIN generally can see everything.

[hannan_t]

Yes, Admin can see everything