I have some questions concerning managing security with ACCESS section :
i want to give access to users depending on the
value given for a group made of the concatanation of 2 fields.
I want give access to a user that have for
example : For Qlik2, the value of EXT or INT field equal to 33 OR 10.
Here is my exemple -->
Section Access :
LOAD * INLINE [
ACCESS, USERID, EXT_INT
ADMIN,INTERNAL\sa_scheduler, *
USER, MTL/Qlik1, *|*
USER, MTL/Qlik2, 33|10
USER, MTL/Qlik3, 51|18
USER, MTL/Qlik4, 76|76
USER, MTL/Qlik5, 51|51
]=
where 1=1;
Section Application : (QVD)
Table-test:
Seq. No. XXXXXXX Ext Int EXT_INT*
1 99 YYYYYYYYYY 42 18 42|18
2 99 YYYYYYYYYY 51 23 51|23
3 99 YYYYYYYYYY 63 51 63|51
4 99 YYYYYYYYYY 66 11 66|11
5 99 YYYYYYYYYY 12 21 12|21
6 99 YYYYYYYYYY 10 11 10|11
7 99 YYYYYYYYYY 51 77 51|77
8 99 YYYYYYYYYY 66 32 66|32
* : The last column is a concatenation of fields EXT and INT
This is what i would like :
I want user Qlik1 to have access to every record of Table-test (1 to 😎
I want user Qlik2 to have access to record 6
I want user Qlik3 to have access to record 1, 2, 3 and 7
I want user Qlik4 to have no access
I want user Qlik5 to have access to record 2, 3 et 7
