Section Access -ALL data visibility

[pradeep92]

Section access;

LOAD * INLINE [

ACCESS, Userid, FIELD,Password

ADMIN, USER1, ,user1

ADMIN, USER2,*,user2

USER, USER3,A,user3

USER, USER4,B,user4

];

section application;

Linked_table:

load * Inline[

FIELD,Fieldvalue

A,10
B,20

C,30

D,40

];

My question is how could I see all the data .. I understand if I login by USER2 , I can See Data relevant to A and B but I want to see ABCD relevant data too. How should i proceed with the script ?

[sunny_talwar · Accepted solution]

Try this

LOAD * INLINE [

ACCESS, Userid, FIELD,Password

ADMIN, USER1, ,user1

ADMIN, USER2,A,user2

ADMIN, USER2,B,user2

ADMIN, USER2,C,user2

ADMIN, USER2,D,user2

USER, USER3,A,user3

USER, USER4,B,user4

];

This needs to be done for atleast one time, now you if another user wants to see all A, B, C, D... you can simply use *

LOAD * INLINE [

ACCESS, Userid, FIELD,Password

ADMIN, USER1, ,user1

ADMIN, USER2,A,user2

ADMIN, USER2,B,user2

ADMIN, USER2,C,user2

ADMIN, USER2,D,user2

ADMIN, USER2,*,user5

USER, USER3,A,user3

USER, USER4,B,user4

];

[sunny_talwar]

Also, look here

Section Access change of roles from ADMIN to USER