Mercurial > gemma

annotate schema/demo-data/roles.sql @ 243:d39f897fae16

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Made models for email, user and country driver.Valuer to get rid of some conversions.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 26 Jul 2018 18:37:52 +0200
parents 0c0826063561
children ac760b0f22a9
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 BEGIN;
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 -- System Administrator
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4';
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 -- Water Way Administrators
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4';
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3';
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 -- Water Way Users
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2';
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 COMMIT;