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