Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pedro_Rodriguez
Contributor III
Contributor III

Apply security project/subproject

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

Labels (2)
0 Replies