Mercurial > gemma

annotate schema/demo-data/roles.sql @ 2338:918091d1df72

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
demo-data: fix two user accounts * Make sure that all users also have roles, by deleting the role variants with space for `Johanna Pichler` and `Борис Даманиов` and adapt the user_profile entries accordingly. The defect was introduced with rev 414:c08593afdd02 only updating one of the tables. As we have enough variants, deleting some is fine.
author Bernhard Reiter <bernhard@intevation.de>
date Tue, 19 Feb 2019 17:17:23 +0100
parents 50dd4ff7907e
children ca7821e1f720
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';
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 "JohannaPichler"
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 "Katharina Gruber"
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 'ka2Tha3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
40 CREATE ROLE "Maximilian Wimmer"
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 'ma2Xim3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
42 CREATE ROLE "Ivo Marković"
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 'iv2Oma3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
44 CREATE ROLE "Leonard Vuković"
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 'le2Ona3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
46 CREATE ROLE "Neven Novak"
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 'ne2Ven3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
48 CREATE ROLE "Elena Popescu"
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 'el2Ena3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
50 CREATE ROLE "Eugen Munteanu"
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 'au2Gen3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
52 CREATE ROLE "Gabriela Gheorghe"
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 'ga2Bri3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
54 CREATE ROLE "Marina Stoica"
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 'ma2Rin3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
56 CREATE ROLE "БорисДаманиов"
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 'bo2Ris3';
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 'fi2Dan3';
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 'ko2Nst3';
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 'Lj2Uba3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
64 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
65 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
66 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
67 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
68 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
69 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3';
403
46a80016293c Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents: 381
diff changeset
70