Mercurial > gemma

annotate schema/demo-data/roles.sql @ 543:b111b765b6cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
client: add hardwired WFS layer to map * As prototype add a getfeature WFS layer asking our own server for the fairways_dimensions. It has deactivate filter code.
author Bernhard Reiter <bernhard@intevation.de>
date Thu, 30 Aug 2018 17:07:35 +0200
parents b31eb28d1fcb
children 50dd4ff7907e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 -- System Administrator
463
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
2 CREATE ROLE sophie
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
3 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
4 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
5 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
6
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 -- Water Way Administrators
463
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
8 CREATE ROLE lucian
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
9 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
10 CREATE ROLE penka
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
11 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
12 CREATE ROLE "David Wagner"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
13 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
14 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
15 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
16 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
17 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
18
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
19 -- Water Way Users
463
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
20 CREATE ROLE oana
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
21 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
22 CREATE ROLE "Johanna Pichler"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
23 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
24 CREATE ROLE "JohannaPichler"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
25 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
26 CREATE ROLE "Katharina Gruber"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
27 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
28 CREATE ROLE "Maximilian Wimmer"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
29 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
30 CREATE ROLE "Ivo Marković"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
31 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
32 CREATE ROLE "Leonard Vuković"
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
33 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
34 CREATE ROLE "Neven Novak"
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 'ne2Ven3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
36 CREATE ROLE "Elena Popescu"
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 'el2Ena3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
38 CREATE ROLE "Eugen Munteanu"
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 'au2Gen3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
40 CREATE ROLE "Gabriela Gheorghe"
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 'ga2Bri3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
42 CREATE ROLE "Marina Stoica"
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 'ma2Rin3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
44 CREATE ROLE "Борис Даманиов"
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 'bo2Ris3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
46 CREATE ROLE "БорисДаманиов"
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 'bo2Ris3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
48 CREATE ROLE "Фидан Дубарова"
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 'fi2Dan3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
50 CREATE ROLE "Дипл. Инж. Константин Ясенов"
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 'ko2Nst3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
52 CREATE ROLE "Люба Ходкивич"
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 'Lj2Uba3';
5611cf72cc92 Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents: 405
diff changeset
54 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
55 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
56 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
57 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
58 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
59 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3';
403
46a80016293c Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents: 381
diff changeset
60