Section Access by APP and User

[#1]

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));

[mrossoit]

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)';

[#3]

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

[mrossoit]

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.