Apply security project/subproject

[Pedro_Rodriguez]

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