Mercurial > gemma

annotate schema/demo-data/roles.sql @ 464:b31eb28d1fcb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix demo data A role that has no entry in internal.user_profiles is not a valid gemma user.
author Tom Gottfried <tom@intevation.de>
date Wed, 22 Aug 2018 16:53:22 +0200
parents 5611cf72cc92
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