Mercurial > gemma
view schema/demo-data/roles.sql @ 261:ab9859981ee3
If a user got renamed kick her/him from the connection pool.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 27 Jul 2018 14:55:47 +0200 |
parents | 0c0826063561 |
children | ac760b0f22a9 |
line wrap: on
line source
BEGIN; -- 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'; COMMIT;