Mercurial > gemma
annotate schema/demo-data/roles.sql @ 5560:f2204f91d286
Join the log lines of imports to the log exports to recover data from them.
Used in SR export to extract information that where in the meta json
but now are only found in the log.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 09 Feb 2022 18:34:40 +0100 |
parents | 1c8de1c695cd |
children |
rev | line source |
---|---|
1318
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
1 -- This is Free Software under GNU Affero General Public License v >= 3.0 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
2 -- without warranty, see README.md and license for details. |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
3 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
4 -- SPDX-License-Identifier: AGPL-3.0-or-later |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
5 -- License-Filename: LICENSES/AGPL-3.0.txt |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
6 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
7 -- Copyright (C) 2018 by via donau |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
9 -- Software engineering by Intevation GmbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
10 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
11 -- Author(s): |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
12 -- * Christine Tschuprine <christine.tschuprine@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
13 -- * Tom Gottfried <tom@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
464
diff
changeset
|
14 |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
15 -- System Administrator |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
16 CREATE ROLE sophie |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
17 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
|
18 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
|
19 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
|
20 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
21 -- Water Way Administrators |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
22 CREATE ROLE lucian |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
23 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
|
24 CREATE ROLE penka |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
25 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
|
26 CREATE ROLE "David Wagner" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
27 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
|
28 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
|
29 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
|
30 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
|
31 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'an2Dre3'; |
3619
ca7821e1f720
Added demo users for HU and RS, import geonames for RS.
Sascha Wilde <wilde@intevation.de>
parents:
2338
diff
changeset
|
32 CREATE ROLE "Željko Popović" |
ca7821e1f720
Added demo users for HU and RS, import geonames for RS.
Sascha Wilde <wilde@intevation.de>
parents:
2338
diff
changeset
|
33 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ze2Ljko4'; |
ca7821e1f720
Added demo users for HU and RS, import geonames for RS.
Sascha Wilde <wilde@intevation.de>
parents:
2338
diff
changeset
|
34 CREATE ROLE "Boglárka Halász" |
ca7821e1f720
Added demo users for HU and RS, import geonames for RS.
Sascha Wilde <wilde@intevation.de>
parents:
2338
diff
changeset
|
35 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'bo2Glarka6'; |
3662
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
36 CREATE ROLE "wwadm-at" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
37 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4AT'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
38 CREATE ROLE "wwadm-sk" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
39 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4SK'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
40 CREATE ROLE "wwadm-hu" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
41 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4HU'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
42 CREATE ROLE "wwadm-hr" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
43 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4HR'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
44 CREATE ROLE "wwadm-rs" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
45 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4RS'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
46 CREATE ROLE "wwadm-ro" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
47 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4RO'; |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
48 CREATE ROLE "wwadm-bg" |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
49 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4BG'; |
3619
ca7821e1f720
Added demo users for HU and RS, import geonames for RS.
Sascha Wilde <wilde@intevation.de>
parents:
2338
diff
changeset
|
50 |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
51 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
52 -- Water Way Users |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
53 CREATE ROLE oana |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
54 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
|
55 CREATE ROLE "JohannaPichler" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
56 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
|
57 CREATE ROLE "Katharina Gruber" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
58 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
|
59 CREATE ROLE "Maximilian Wimmer" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
60 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
|
61 CREATE ROLE "Ivo Marković" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
62 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
|
63 CREATE ROLE "Leonard Vuković" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
64 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
|
65 CREATE ROLE "Neven Novak" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
66 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
|
67 CREATE ROLE "Elena Popescu" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
68 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
|
69 CREATE ROLE "Eugen Munteanu" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
70 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
|
71 CREATE ROLE "Gabriela Gheorghe" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
72 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
|
73 CREATE ROLE "Marina Stoica" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
74 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
|
75 CREATE ROLE "БорисДаманиов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
76 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
|
77 CREATE ROLE "Фидан Дубарова" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
78 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
|
79 CREATE ROLE "Дипл. Инж. Константин Ясенов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
80 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
|
81 CREATE ROLE "Люба Ходкивич" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
82 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
|
83 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
|
84 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
|
85 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
|
86 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
|
87 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
|
88 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3'; |