Mercurial > gemma
diff schema/auth.sql @ 172:a422471db08a
Automate running DB-tests with an extra database
run_tests.sh allows to run database tests easily without
affecting other existing databases and on a clean basis.
Because roles are cluster-wide, they cannot be easily droped
and recreated without affecting other databases. Thus,
moved their creation to roles.sql and in passing removed
unnecessary role 'gemma'.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 12 Jul 2018 16:30:01 +0200 |
| parents | d349db18bece |
| children | 3f7053e53fa6 |
line wrap: on
line diff
--- a/schema/auth.sql Tue Jul 10 14:30:06 2018 +0200 +++ b/schema/auth.sql Thu Jul 12 16:30:01 2018 +0200 @@ -9,13 +9,6 @@ REVOKE CREATE ON SCHEMA public FROM PUBLIC; -- --- Primary GEMMA roles (SRS table 3) --- -CREATE ROLE waterway_user; -CREATE ROLE waterway_admin IN ROLE waterway_user; -CREATE ROLE sys_admin CREATEROLE BYPASSRLS IN ROLE waterway_admin; - --- -- Privileges for waterway_user -- GRANT USAGE ON SCHEMA gemma, gemma_waterway, gemma_fairway TO waterway_user;