Mercurial > gemma
annotate schema/demo-data/roles.sql @ 409:cdd63547930a
Rename external wfs proxy to proxy as it may work for other kind os services like wms, too.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 15 Aug 2018 15:57:36 +0200 |
parents | c08593afdd02 |
children | 5611cf72cc92 |
rev | line source |
---|---|
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 -- System Administrator |
405
c08593afdd02
changed demousers
Christine Tschuprine <christine@intevation.de>
parents:
403
diff
changeset
|
2 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
3 CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann" IN ROLE sys_admin LOGIN PASSWORD 'zi2Mmer3'; |
405
c08593afdd02
changed demousers
Christine Tschuprine <christine@intevation.de>
parents:
403
diff
changeset
|
4 CREATE ROLE "Dipl.-Inform.Stefan-AlbertZimmermann" IN ROLE sys_admin LOGIN PASSWORD 'zi2Mmer3'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
5 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
6 -- Water Way Administrators |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
7 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian3'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
8 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
9 CREATE ROLE "David Wagner" IN ROLE waterway_admin LOGIN PASSWORD 'da2Div3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
10 CREATE ROLE "Christina Kovačević" IN ROLE waterway_admin LOGIN PASSWORD 'ch2Ris3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
11 CREATE ROLE "Andrej Kovačič" IN ROLE waterway_admin LOGIN PASSWORD 'an2Dre3'; |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
12 |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
13 -- Water Way Users |
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
14 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
15 CREATE ROLE "Johanna Pichler" IN ROLE waterway_user LOGIN PASSWORD 'jo2Han3'; |
405
c08593afdd02
changed demousers
Christine Tschuprine <christine@intevation.de>
parents:
403
diff
changeset
|
16 CREATE ROLE "JohannaPichler" IN ROLE waterway_user LOGIN PASSWORD 'jo2Han3'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
17 CREATE ROLE "Katharina Gruber" IN ROLE waterway_user LOGIN PASSWORD 'ka2Tha3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
18 CREATE ROLE "Maximilian Wimmer" IN ROLE waterway_user LOGIN PASSWORD 'ma2Xim3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
19 CREATE ROLE "Ivo Marković" IN ROLE waterway_user LOGIN PASSWORD 'iv2Oma3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
20 CREATE ROLE "Leonard Vuković" IN ROLE waterway_user LOGIN PASSWORD 'le2Ona3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
21 CREATE ROLE "Neven Novak" IN ROLE waterway_user LOGIN PASSWORD 'ne2Ven3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
22 CREATE ROLE "Elena Popescu" IN ROLE waterway_user LOGIN PASSWORD 'el2Ena3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
23 CREATE ROLE "Eugen Munteanu" IN ROLE waterway_user LOGIN PASSWORD 'au2Gen3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
24 CREATE ROLE "Gabriela Gheorghe" IN ROLE waterway_user LOGIN PASSWORD 'ga2Bri3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
25 CREATE ROLE "Marina Stoica" IN ROLE waterway_user LOGIN PASSWORD 'ma2Rin3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
26 CREATE ROLE "Борис Даманиов" IN ROLE waterway_user LOGIN PASSWORD 'bo2Ris3'; |
405
c08593afdd02
changed demousers
Christine Tschuprine <christine@intevation.de>
parents:
403
diff
changeset
|
27 CREATE ROLE "БорисДаманиов" IN ROLE waterway_user LOGIN PASSWORD 'bo2Ris3'; |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
28 CREATE ROLE "Фидан Дубарова" IN ROLE waterway_user LOGIN PASSWORD 'fi2Dan3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
29 CREATE ROLE "Дипл. Инж. Константин Ясенов" IN ROLE waterway_user LOGIN PASSWORD 'ko2Nst3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
30 CREATE ROLE "Люба Ходкивич" IN ROLE waterway_user LOGIN PASSWORD 'Lj2Uba3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
31 CREATE ROLE "Milana Božič" IN ROLE waterway_user LOGIN PASSWORD 'mi2Lan3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
32 CREATE ROLE "Vladislav Zupančič" IN ROLE waterway_user LOGIN PASSWORD 'vl2Adi3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
33 CREATE ROLE "Zuzanna Korošec" IN ROLE waterway_user LOGIN PASSWORD 'zu2Zan3'; |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
381
diff
changeset
|
34 |