database-users

migrations__V001__add_application_user.sql

DO
$do$
BEGIN
   IF EXISTS (
      SELECT FROM pg_catalog.pg_roles
      WHERE  rolname = 'eos_app_rw') THEN

      RAISE NOTICE 'Role "eos_app_rw" already exists. Skipping.';
   ELSE
      CREATE USER eos_app_rw;
   END IF;
END
$do$;

migrations__V002__grant_application_user_permissions.sql

GRANT USAGE ON SCHEMA public TO eos_app_rw;
GRANT INSERT, UPDATE, DELETE, SELECT ON ALL TABLES IN SCHEMA public TO eos_app_rw;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO eos_app_rw;