Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a doubt with Section Access. ¿It's possible to include a filter of Document Name to establish permission in Access Point?
I have one xls to set permission for each app and would like to use only one XLS for all apps.
I'm tried to do this, but doesn't work, ¿any help?
SET V_APP = 'DocumentName()';
SECTION Access;
ACCESO:
LOAD ACCESS,
upper(Usuario) as Usuario,
upper(APP)
FROM
(ooxml, embedded labels, table is ACCESO)
Where APP =upper($(V_APP));
You need also password field in your xlsx.
Try:
SET V_APP = upper(DocumentName());
SECTION Access;
ACCESO:
LOAD ACCESS,
upper(Usuario) as USERID,
upper(Password) as PASSWORD,
upper(APP)
FROM
(ooxml, embedded labels, table is ACCESO)
Where APP ='$(V_APP)';
Hi Massimiliano, the access is fine. We use a local domain controller to set a password and dont need load a password field too.
Just need to link "DocumentName()" with "NamedUser()" for establish Section Access in Script, i think that is posible with publisher but not sure in Script.
Thanks for response Massimiliano
The correct way to manage accesses to your Access Point pass through CALs but in your question you seem to want a second level of control.
If you want to use section access at all costs I'm pretty sure that your table ACCESO must contains at least ACCESS, USERID and PASSWORD fields with upper values into them.
If your password list resides in another repository you should join fields from your xlsx to passwords using username as link.