This table contains the access rights to the different paths of the ELN application.
The table is built in the job.
| COLUMN NAME | DESCRIPTION |
|---|---|
| ENTITY_PATH | It indicates if the ELN entity path (the path of the resource in the ELN application) |
| ENTITY_PAT_LN 0-11 | It is a breaking on the path into its different components |
| USER_LOGIN_ID | The id of the user as provided by the ELN database. |
| ENTITY_ROLE_NAME | The name of the role the user has on this resource. It indicates the level of permission the user has |
The job uses the standard SCD job principle.
1-This job reads newly added data from the table from the ODS table ODS_0000_F018_F_D_IDBS_EWB_SOLVAY_CUSTOM_DM_UserAccessPath_Full
2 - We we join the ODS_0000_F018_F_D_IDBS_EWB_SOLVAY_CUSTOM_DM_UserAccessPath_Full table with the DIM_ELN_USERS table to only get results for active users.
3 - We join with the table DIM_ELN_ENTITY_ROLE_PERMISSIONS on the ENTITYROLE column to add an attribute saying if the user has access to see private entities (i.e. an entity whose access are granted on a need to know basis).
4 - We take the list of all ELN entities with their path (table ODS_0000_F022_I_D_IDBS_EWB_CORE_LATEST_ENTITY_VERSIONS) and in the tMap we add a column to understand if this entity is a private entity (i.e. an entity whose access are granted on a need to know basis).
5 - After that a cross join is made with the ODS_0000_F022_I_D_IDBS_EWB_CORE_LATEST_ENTITY_VERSIONS table in order to get all related paths. This operation generates a lot of rows.
In order to split the paths into its different components, a custom routine, called Eln has been developed. The objective of the routine is to count the number of slashes ("/") in the entity path which allows to understand how many level the entity path contains. The routine is used in the calculation of the different ENTITY_PATH_LN columns.
Roles in the ELN are done on a specific entity and they are propagated to its children. The aim of the cross join is to create the list of all entities a user has access to (i.e. replicate the permission on all children entity paths).
The input table ODS_0000_F018_F_D_IDBS_EWB_SOLVAY_CUSTOM_DM_UserAccessPath_Full returns permissions per a specific entity path this means that we will have issues in case two entities have the same entity path. This is very rare but an occurrence exists '
/Root/Science & Technology - R&I Function/S&T-R&I Lyon/CODP/GBU-Partner-Restricted/Specialty Polymers/ISTANBUL.
A fix should be included in the ELN database to fix it so that the view contains the ENTITY_ID.