Mercurial > gemma
annotate 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 |
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; |