Mercurial > gemma

comparison schema/demo-data/roles.sql @ 463:5611cf72cc92

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add metamorphic database role and user e.g. for GeoServer
author Tom Gottfried <tom@intevation.de>
date Wed, 22 Aug 2018 16:48:56 +0200
parents c08593afdd02
children b31eb28d1fcb
comparison
equal deleted inserted replaced
462:62a0adc8cdcd 463:5611cf72cc92
1 -- System Administrator 1 -- System Administrator
2 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4'; 2 CREATE ROLE sophie
3 CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann" IN ROLE sys_admin LOGIN PASSWORD 'zi2Mmer3'; 3 IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'so2Phie4';
4 CREATE ROLE "Dipl.-Inform.Stefan-AlbertZimmermann" IN ROLE sys_admin LOGIN PASSWORD 'zi2Mmer3'; 4 CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann"
5 IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'zi2Mmer3';
6 CREATE ROLE "Dipl.-Inform.Stefan-AlbertZimmermann"
7 IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'zi2Mmer3';
5 8
6 -- Water Way Administrators 9 -- Water Way Administrators
7 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian3'; 10 CREATE ROLE lucian
8 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3'; 11 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'lu2Cian3';
9 CREATE ROLE "David Wagner" IN ROLE waterway_admin LOGIN PASSWORD 'da2Div3'; 12 CREATE ROLE penka
10 CREATE ROLE "Christina Kovačević" IN ROLE waterway_admin LOGIN PASSWORD 'ch2Ris3'; 13 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'pe2Nka3';
11 CREATE ROLE "Andrej Kovačič" IN ROLE waterway_admin LOGIN PASSWORD 'an2Dre3'; 14 CREATE ROLE "David Wagner"
15 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'da2Div3';
16 CREATE ROLE "Christina Kovačević"
17 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ch2Ris3';
18 CREATE ROLE "Andrej Kovačič"
19 IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'an2Dre3';
12 20
13 -- Water Way Users 21 -- Water Way Users
14 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2'; 22 CREATE ROLE oana
15 CREATE ROLE "Johanna Pichler" IN ROLE waterway_user LOGIN PASSWORD 'jo2Han3'; 23 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'oa2Na2';
16 CREATE ROLE "JohannaPichler" IN ROLE waterway_user LOGIN PASSWORD 'jo2Han3'; 24 CREATE ROLE "Johanna Pichler"
17 CREATE ROLE "Katharina Gruber" IN ROLE waterway_user LOGIN PASSWORD 'ka2Tha3'; 25 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3';
18 CREATE ROLE "Maximilian Wimmer" IN ROLE waterway_user LOGIN PASSWORD 'ma2Xim3'; 26 CREATE ROLE "JohannaPichler"
19 CREATE ROLE "Ivo Marković" IN ROLE waterway_user LOGIN PASSWORD 'iv2Oma3'; 27 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3';
20 CREATE ROLE "Leonard Vuković" IN ROLE waterway_user LOGIN PASSWORD 'le2Ona3'; 28 CREATE ROLE "Katharina Gruber"
21 CREATE ROLE "Neven Novak" IN ROLE waterway_user LOGIN PASSWORD 'ne2Ven3'; 29 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ka2Tha3';
22 CREATE ROLE "Elena Popescu" IN ROLE waterway_user LOGIN PASSWORD 'el2Ena3'; 30 CREATE ROLE "Maximilian Wimmer"
23 CREATE ROLE "Eugen Munteanu" IN ROLE waterway_user LOGIN PASSWORD 'au2Gen3'; 31 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Xim3';
24 CREATE ROLE "Gabriela Gheorghe" IN ROLE waterway_user LOGIN PASSWORD 'ga2Bri3'; 32 CREATE ROLE "Ivo Marković"
25 CREATE ROLE "Marina Stoica" IN ROLE waterway_user LOGIN PASSWORD 'ma2Rin3'; 33 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'iv2Oma3';
26 CREATE ROLE "Борис Даманиов" IN ROLE waterway_user LOGIN PASSWORD 'bo2Ris3'; 34 CREATE ROLE "Leonard Vuković"
27 CREATE ROLE "БорисДаманиов" IN ROLE waterway_user LOGIN PASSWORD 'bo2Ris3'; 35 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'le2Ona3';
28 CREATE ROLE "Фидан Дубарова" IN ROLE waterway_user LOGIN PASSWORD 'fi2Dan3'; 36 CREATE ROLE "Neven Novak"
29 CREATE ROLE "Дипл. Инж. Константин Ясенов" IN ROLE waterway_user LOGIN PASSWORD 'ko2Nst3'; 37 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ne2Ven3';
30 CREATE ROLE "Люба Ходкивич" IN ROLE waterway_user LOGIN PASSWORD 'Lj2Uba3'; 38 CREATE ROLE "Elena Popescu"
31 CREATE ROLE "Milana Božič" IN ROLE waterway_user LOGIN PASSWORD 'mi2Lan3'; 39 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'el2Ena3';
32 CREATE ROLE "Vladislav Zupančič" IN ROLE waterway_user LOGIN PASSWORD 'vl2Adi3'; 40 CREATE ROLE "Eugen Munteanu"
33 CREATE ROLE "Zuzanna Korošec" IN ROLE waterway_user LOGIN PASSWORD 'zu2Zan3'; 41 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'au2Gen3';
42 CREATE ROLE "Gabriela Gheorghe"
43 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ga2Bri3';
44 CREATE ROLE "Marina Stoica"
45 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Rin3';
46 CREATE ROLE "Борис Даманиов"
47 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3';
48 CREATE ROLE "БорисДаманиов"
49 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3';
50 CREATE ROLE "Фидан Дубарова"
51 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'fi2Dan3';
52 CREATE ROLE "Дипл. Инж. Константин Ясенов"
53 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ko2Nst3';
54 CREATE ROLE "Люба Ходкивич"
55 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'Lj2Uba3';
56 CREATE ROLE "Milana Božič"
57 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'mi2Lan3';
58 CREATE ROLE "Vladislav Zupančič"
59 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'vl2Adi3';
60 CREATE ROLE "Zuzanna Korošec"
61 IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3';
34 62