Mercurial > gemma
view schema/demo-data/roles.sql @ 211:e7826710d9c4
Make responsibility area mandatory
Each waterway administrator has to have a responsibility
area assigned, which is now ensured by referencing the
respective table instead of countries directly.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 23 Jul 2018 16:45:27 +0200 |
parents | 0c0826063561 |
children | ac760b0f22a9 |
line wrap: on
line source
BEGIN; -- System Administrator CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4'; -- Water Way Administrators CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4'; CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3'; -- Water Way Users CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2'; CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3'; COMMIT;