Mercurial > gemma
view schema/demo-data/roles.sql @ 345:b97b3172c61a
Add staging feature to more tables
Added tables currently only have limited visibility for waterway_user
but not yet policies for write access.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 06 Aug 2018 15:19:05 +0200 |
parents | fd04bccae6ca |
children | 1cf1423d98e0 |
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;