Where are users and Platform roles stored?

Platform handles these concepts in terms of security:

ConfigDB

The ConfigDB is the database that stores the definition of all the platform concepts (Entities, DataFlows, Dashboards,...) and also stores all the security concepts.

By default MariaDB is used, although Postgresql and commercial databases are also supported.

Users

These are the users that have access to the platform.

They are stored in the USER table that has this structure:

If these users are not federated with another system (e.g. with a corporate LDAP) in the USER table all the user information is stored, including the password, which is stored in this table encrypted and following a user definable pattern: Patrón PASSWORD de usuario en configuración centralizada

If the users are federated with another system, this USER table simply stores the user_id with the link to the user of the system to which it is federated.

Roles

In Platform a set of Roles are defined for platform access.

These roles are defined in the ROLE_TYPE table and are associated to the user with the FK role_id (a user can only have one active role).

Â