gemma: schema/demo-data/roles.sql annotate

annotate schema/demo-data/roles.sql @ 3678:8f58851927c0

client: make layer factory only return new layer config for individual maps instead of each time it is invoked. The purpose of the factory was to support multiple maps with individual layers. But returning a new config each time it is invoked leads to bugs that rely on the layer's state. Now this factory reuses the same objects it created before, per map.

author	Markus Kottlaender <markus@intevation.de>
date	Mon, 17 Jun 2019 17:31:35 +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';

Mercurial > gemma

annotate schema/demo-data/roles.sql @ 3678:8f58851927c0