Mercurial > gemma

annotate schema/demo-data/roles.sql @ 211:e7826710d9c4

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