create-users.sql

/* Creates default users for local development */

CREATE USER "local_setup_flyway" WITH INHERIT IN ROLE cwa_flyway ENCRYPTED PASSWORD 'local_setup_flyway';
CREATE USER "local_setup_submission" WITH INHERIT IN ROLE cwa_submission ENCRYPTED PASSWORD 'local_setup_submission';
CREATE USER "local_setup_distribution" WITH INHERIT IN ROLE cwa_distribution ENCRYPTED PASSWORD 'local_setup_distribution';

/* --------------- Interoperability --------------- */

CREATE USER "local_setup_callback" WITH INHERIT IN ROLE cwa_federation_callback ENCRYPTED PASSWORD 'local_setup_callback';
CREATE USER "local_setup_download" WITH INHERIT IN ROLE cwa_federation_download ENCRYPTED PASSWORD 'local_setup_download';
CREATE USER "local_setup_upload" WITH INHERIT IN ROLE cwa_federation_upload ENCRYPTED PASSWORD 'local_setup_upload';

/* --------------- Swiss Federation Gateway --------------- */
CREATE USER "local_setup_sgs_upload" WITH INHERIT IN ROLE cwa_chgs_upload ENCRYPTED PASSWORD 'local_setup_sgs_upload';