Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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?
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
I was facing the same issue. You also have to add Station_ID in PermisosAuto.xlsx and you'll get it resolved.
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.
I agree, ADMIN generally can see everything.
Yes, Admin can see everything