Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
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;