Mercurial > gemma

view schema/roles.sql @ 418:c70ddc6eb168

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Don't allow user names to contain any of the following characters \"':;
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 16 Aug 2018 13:14:46 +0200
parents ac760b0f22a9
children 5611cf72cc92
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 password reset only
CREATE ROLE pw_reset;