Mercurial > gemma

view schema/roles.sql @ 253:322c3d0e05ef

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
The column in sys_admin.list_users is called rolname not rolename.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 27 Jul 2018 12:12:48 +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;