Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
175:3f7053e53fa6 176:0c0826063561
1 BEGIN;
2
3 -- System Administrator
4 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4';
5
6 -- Water Way Administrators
7 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4';
8 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3';
9
10 -- Water Way Users
11 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2';
12 CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';
13
14 COMMIT;