Mercurial > gemma
view schema/roles.sql @ 4364:496bbf0f618c
Move definition of published services to default configuration
We rely on existance of these layers in some places, e.g. default
configuration, already in some places. Further, default configuration
setup is, in contrast to demo data, part of automatic database tests.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 09 Sep 2019 17:39:57 +0200 |
parents | 2304778c4432 |
children | a554d7ca26ee |
line wrap: on
line source
-- This is Free Software under GNU Affero General Public License v >= 3.0 -- without warranty, see README.md and license for details. -- SPDX-License-Identifier: AGPL-3.0-or-later -- License-Filename: LICENSES/AGPL-3.0.txt -- Copyright (C) 2018 by via donau -- – Österreichische Wasserstraßen-Gesellschaft mbH -- Software engineering by Intevation GmbH -- Author(s): -- * Tom Gottfried <tom@intevation.de> -- -- 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;