Mercurial > gemma

annotate schema/demo-data/roles.sql @ 5666:37c2354a6024 clickable-links

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Render links only to known bottlenecks
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 05 Dec 2023 15:34:31 +0100
parents 1c8de1c695cd
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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';