Mercurial > gemma

annotate schema/demo-data/roles.sql @ 409:cdd63547930a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
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
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