Mercurial > gemma
annotate schema/demo-data/roles.sql @ 978:544a5cfe07cd
Started with endpoint for uploading sounding result and trigger respective import job.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 18 Oct 2018 18:37:19 +0200 |
parents | b31eb28d1fcb |
children | 50dd4ff7907e |
rev | line source |
---|---|
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 -- System Administrator |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
2 CREATE ROLE sophie |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
3 IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'so2Phie4'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
4 CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
5 IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'zi2Mmer3'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
6 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
7 -- Water Way Administrators |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
8 CREATE ROLE lucian |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
9 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'lu2Cian3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
10 CREATE ROLE penka |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
11 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'pe2Nka3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
12 CREATE ROLE "David Wagner" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
13 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'da2Div3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
14 CREATE ROLE "Christina Kovačević" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
15 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ch2Ris3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
16 CREATE ROLE "Andrej Kovačič" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
17 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'an2Dre3'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
18 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
19 -- Water Way Users |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
20 CREATE ROLE oana |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
21 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'oa2Na2'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
22 CREATE ROLE "Johanna Pichler" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
23 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
24 CREATE ROLE "JohannaPichler" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
25 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
26 CREATE ROLE "Katharina Gruber" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
27 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ka2Tha3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
28 CREATE ROLE "Maximilian Wimmer" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
29 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Xim3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
30 CREATE ROLE "Ivo Marković" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
31 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'iv2Oma3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
32 CREATE ROLE "Leonard Vuković" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
33 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'le2Ona3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
34 CREATE ROLE "Neven Novak" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
35 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ne2Ven3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
36 CREATE ROLE "Elena Popescu" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
37 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'el2Ena3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
38 CREATE ROLE "Eugen Munteanu" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
39 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'au2Gen3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
40 CREATE ROLE "Gabriela Gheorghe" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
41 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ga2Bri3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
42 CREATE ROLE "Marina Stoica" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
43 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Rin3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
44 CREATE ROLE "Борис Даманиов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
45 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
46 CREATE ROLE "БорисДаманиов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
47 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
48 CREATE ROLE "Фидан Дубарова" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
49 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'fi2Dan3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
50 CREATE ROLE "Дипл. Инж. Константин Ясенов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
51 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ko2Nst3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
52 CREATE ROLE "Люба Ходкивич" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
53 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'Lj2Uba3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
54 CREATE ROLE "Milana Božič" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
55 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'mi2Lan3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
56 CREATE ROLE "Vladislav Zupančič" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
57 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'vl2Adi3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
58 CREATE ROLE "Zuzanna Korošec" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
59 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
60 |