Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
VijayAntoineMICK
Contributor II
Contributor II

Open All Datas to USERS when using composite key

Hello,

How can I open only on reading all datas to a user when I using a section access please ?

For example, I am a user V.MICK and I want to show all datas for me, but want to apply my session access restrictions for A.B and other users with this code you can see below : 

 

LIB CONNECT TO 'MSS_I_RHL_DEV';
EPA:
LOAD "EPA_CODE" & '|' & "PERIODE_CHGT" & '|' & LEGION as varInfos
SQL SELECT "EPA_CODE","SSV_CODE","EPA_NOM",TNS,"SITE_ID","SERVEUR
FROM "I_INFORHL_DWH"."inforhl_db".EPA;

// ----------
INNER JOIN (EPA)
INDICATEURS_EPA:
LOAD "PERIODE_ID","EPA_CODE" AS "Code d'EPA","SITE_ID","NBR_NUIT_
SQL SELECT "PERIODE_ID","EPA_CODE","SITE_ID","NBR_NUIT_HOT","CHA_
FROM "I_INFORHL_DWH"."inforhl_db"."INDICATEURS_EPA";


// ----------SECTION-ACCESS--------


SECTION ACCESS;
AUTHORIZATION:
LOAD*INLINE [
ACCESS, USERID, REDUIRE_LES_INFORMATIONS
ADMIN,INTERNAL\SA_SCHEDULER
ADMIN,DR-CPT\V.MICK,
USER,DR-CPT\A.B,2
USER,DR-CPT\S.KN,2
USER,DR-CPT\M.J,2
USER,DR-CPT\L.R,2
USER,FAKE_USER,1
USER,FAKE_USER,2
USER,FAKE_USER,3
USER,FAKE_USER,4
];


SECTION APPLICATION;
REDUCTION_DES_INFORMATIONS_CONCAT_EPACODE_PERIODECHGT_LEGION:
LOAD*INLINE [
REDUIRE_LES_INFORMATIONS, varInfos
1, ABE|202102|O
2, ABE|202102|O
3, GHO|202102|N
];

 

I am using a composite key to remove acces to multiple datas to user, I dont want to put ADMIN section access for V.MICK because I want to Only show to him  all datas and not allow to him modify access.

Thanks a lot in advance,

Regards,

Antoine Vijay MICK

 

Labels (1)
0 Replies