Mercurial > gemma

diff schema/demo-data/roles.sql @ 176:0c0826063561

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;