Mercurial > gemma

view schema/roles.sql @ 762:01ba06da8f46

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Factored repojection of coordinates to own logic as we need it to reproject the results of the cross sections back to WGS84.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 25 Sep 2018 10:35:17 +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;