Mercurial > gemma

view schema/roles.sql @ 1239:d842d9d10872

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sounding result import: Added the feature to override bottleneck, EPSG, depth reference and date in meta.json by POST arguments.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 20 Nov 2018 17:04:06 +0100
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;