Hi all,
Lets say y have the following data, Records with Project and records with subproject. I'm asked to give permisions in section access by cod_dpt. If a user can see a project, he should be given access to all of its subprojects
(Eg: user A can see cod_dpt=00002 so he must see Project P/01 but also the first record (P/01-001) 'cos it contains on subproject belonging P/01)
This is not the other way round (a user that can see a subproject not necesarily is allowed to see its project, only the ones allowed for its cod_dpt)
LOAD * Inline
[
project, subproject, cod_dpt
P/01,P/01-001,00001
P/01 ,00002
P/02, ,00005
P/02,P/02-004,00004
P/03, ,00005
P/03,P/03-001,00002
P/03,P/03-002,00007
P/05,P/05-001,00002
P/06, ,00003
];
Access:
Load * Inline [
USERID, ACCESS, cod_dpt
A, USER, 00002
A, USER, 00005
B, USER, 00003
C, USER, *
];
With this section access, the A user should see records 1, 2, 6, 8, 3, 4, 5, 7,
the B user should see record 9.
Thanks a lot in advance
