Mercurial > gemma

view schema/roles.sql @ 734:1581ba78a360

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
client: prepare for fairway intersection for profile * Add calculation of features which intersect the extend of the profileLine as preparation for the more expensive detailed intersect operation.
author Bernhard Reiter <bernhard@intevation.de>
date Mon, 24 Sep 2018 09:56:51 +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;