Mercurial > gemma
view schema/demo-data/roles.sql @ 465:ab07eb290fa3
Drop metamorph role too when tearing down database.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 22 Aug 2018 17:21:25 +0200 |
parents | b31eb28d1fcb |
children | 50dd4ff7907e |
line wrap: on
line source
-- System Administrator CREATE ROLE sophie IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'so2Phie4'; CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann" IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'zi2Mmer3'; -- Water Way Administrators CREATE ROLE lucian IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'lu2Cian3'; CREATE ROLE penka IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'pe2Nka3'; CREATE ROLE "David Wagner" IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'da2Div3'; CREATE ROLE "Christina Kovačević" IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ch2Ris3'; CREATE ROLE "Andrej Kovačič" IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'an2Dre3'; -- Water Way Users CREATE ROLE oana IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'oa2Na2'; CREATE ROLE "Johanna Pichler" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3'; CREATE ROLE "JohannaPichler" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3'; CREATE ROLE "Katharina Gruber" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ka2Tha3'; CREATE ROLE "Maximilian Wimmer" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Xim3'; CREATE ROLE "Ivo Marković" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'iv2Oma3'; CREATE ROLE "Leonard Vuković" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'le2Ona3'; CREATE ROLE "Neven Novak" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ne2Ven3'; CREATE ROLE "Elena Popescu" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'el2Ena3'; CREATE ROLE "Eugen Munteanu" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'au2Gen3'; CREATE ROLE "Gabriela Gheorghe" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ga2Bri3'; CREATE ROLE "Marina Stoica" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Rin3'; CREATE ROLE "Борис Даманиов" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3'; CREATE ROLE "БорисДаманиов" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3'; CREATE ROLE "Фидан Дубарова" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'fi2Dan3'; CREATE ROLE "Дипл. Инж. Константин Ясенов" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ko2Nst3'; CREATE ROLE "Люба Ходкивич" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'Lj2Uba3'; CREATE ROLE "Milana Božič" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'mi2Lan3'; CREATE ROLE "Vladislav Zupančič" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'vl2Adi3'; CREATE ROLE "Zuzanna Korošec" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3';