Mercurial > gemma
annotate schema/demo-data/roles.sql @ 4592:680f1d8802f0
STRTree: Add a builder that ignores triangles which are filtered out before.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 09 Oct 2019 11:50:33 +0200 |
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'; |