Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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