Section Access for all the values (*)

[reshmakala]

Hi all,

I am trying to implement section access on a field with NTNAME. Here is my script

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

This works perfectly fine on desktop. When I publish this on Server, it says "Failed to open document. Access denied". When tried putting in a value for FIELD beside Admin, I can see the data related to that value or else the access is denied. I cannot manually include all the values for FIELD as I have few hundreds. How can I specify ALL values for Admins. Using * is giving me only A and B access.

Thank you.

[krishnacbe]

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

*;

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;

[krishnacbe · Accepted solution]

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

*;

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1, *

ADMIN, USER2, *

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;