Skip to content

Security

Edalitics enables different levels of security. Security can be defined both at the data model level and at the table and record levels.

At the model level it can be defined that:

  • The model is public and any user can view the model. Security filters are defined at the table and column level.
  • The model is private and only users and/or roles defined in security can see the model.

At the table level, it can be defined that a user or group can see or not a table.

At the column level, you can define that a user or group can see or not a column.

At the data level, security can be defined:

  • Static: Defining what values each user or group can see.
  • Dynamic: Defining which query will be resolved on that column to obtain the possible values.
    • Groups: The query will be the query that will return the possible values for that group _ where column in ( select values from table where group = ‘EDA_ROLES’ )_
    • Users: The query will be the query that will return the possible values for that user. Having the keyword EDA_USER that will be replaced by the user login that makes the query. _ where column in ( select values from table where user = ‘EDA_USER’ )_