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";
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.