Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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