Docker-Compose/.templates/init-userdb.sql
2024-12-08 20:14:01 +01:00

7 lines
No EOL
287 B
SQL

CREATE USER 'odc'@'%' IDENTIFIED BY '<open-datenschutzcenter-pw>';
CREATE DATABASE odc;
GRANT ALL PRIVILEGES ON odc.* TO 'odc'@'%';
CREATE USER 'keycloak'@'%' IDENTIFIED BY '<keycloak-pw>';
CREATE DATABASE keycloak;
GRANT ALL PRIVILEGES ON keycloak.* TO 'keycloak'@'%';
FLUSH PRIVILEGES;