Initialization PostgreSQL Script
Closed this issue · 2 comments
Currently we need a script that will create the needed databases for our project, as well as, creating the users. Users can specify the access privileges of the database. For example, the keycloak user will only have access to its specific database. Demonstrator user will only have access to the students database. The initialization of the databases and the users should be in a script called whenever the database image fires-up. For now, we can have: kecyloak user (Keycloak internal service will be using), admin user (backend will be using to access the students data), And we need 2 main databases, the keycloak database (auth_db) and the CAP database (cap_db). Each on will have its own user that will have write/read privileges as explained above.
The current CAP Database design is as follows:
