Mercurial > gemma
diff schema/demo-data/roles.sql @ 176:0c0826063561
Separate cluster and database specific commands
This allows to setup more than one database with demo data
on the same cluster by using only the script with database
specific commands.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 17 Jul 2018 12:01:14 +0200 |
parents | |
children | ac760b0f22a9 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/demo-data/roles.sql Tue Jul 17 12:01:14 2018 +0200 @@ -0,0 +1,14 @@ +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;