Mercurial > gemma
view schema/demo-data/roles.sql @ 381:1cf1423d98e0
Allow adding new roles to demo-data
Wrapping the script in a transaction block did not allow
to add a new role without dropping all other roles before.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 10 Aug 2018 14:59:23 +0200 |
parents | fd04bccae6ca |
children | 46a80016293c |
line wrap: on
line source
-- System Administrator CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4'; -- Water Way Administrators CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4'; CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3'; -- Water Way Users CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2'; CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';