Mercurial > gemma
annotate schema/demo-data/roles.sql @ 2055:6594903a14e8 unify_imports
Scheduler: Fixed SQL statement once again.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 28 Jan 2019 14:01:56 +0100 |
parents | 50dd4ff7907e |
children | 918091d1df72 |
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'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
32 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
33 -- Water Way Users |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
34 CREATE ROLE oana |
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 'oa2Na2'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
36 CREATE ROLE "Johanna Pichler" |
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 'jo2Han3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
38 CREATE ROLE "JohannaPichler" |
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 'jo2Han3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
40 CREATE ROLE "Katharina Gruber" |
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 'ka2Tha3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
42 CREATE ROLE "Maximilian Wimmer" |
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 'ma2Xim3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
44 CREATE ROLE "Ivo Marković" |
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 'iv2Oma3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
46 CREATE ROLE "Leonard Vuković" |
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 'le2Ona3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
48 CREATE ROLE "Neven Novak" |
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 'ne2Ven3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
50 CREATE ROLE "Elena Popescu" |
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 'el2Ena3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
52 CREATE ROLE "Eugen Munteanu" |
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 'au2Gen3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
54 CREATE ROLE "Gabriela Gheorghe" |
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 'ga2Bri3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
56 CREATE ROLE "Marina Stoica" |
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 'ma2Rin3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
58 CREATE ROLE "Борис Даманиов" |
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 'bo2Ris3'; |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
60 CREATE ROLE "БорисДаманиов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
61 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
|
62 CREATE ROLE "Фидан Дубарова" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
63 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
|
64 CREATE ROLE "Дипл. Инж. Константин Ясенов" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
65 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
|
66 CREATE ROLE "Люба Ходкивич" |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
405
diff
changeset
|
67 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
|
68 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
|
69 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
|
70 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
|
71 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
|
72 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
|
73 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
74 |