Mercurial > gemma

view schema/roles.sql @ 495:5c08afd15ce7 metamorph-for-all

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Give file containing the session store a more suited name.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 24 Aug 2018 14:28:05 +0200
parents 3af7ca761f6a
children 6590208e3ee1
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;

--
-- Special roles
--

-- A role that is intended to be used for backend- or
-- GeoServer-connections on which SET ROLE has to be used to
-- gain privileges of a specific role
CREATE ROLE metamorph NOINHERIT;