Mercurial > gemma

view schema/roles.sql @ 210:a0e2c6bb3cb3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove obsolete GRANT on user_profiles Even sys_admin should write in this table only via user management functions.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 16:40:21 +0200
parents 88d21c29cf04
children ac760b0f22a9
line wrap: on
line source

--
-- Primary GEMMA roles
--
CREATE ROLE waterway_user;
CREATE ROLE waterway_admin IN ROLE waterway_user;
CREATE ROLE sys_admin IN ROLE waterway_admin;