Mercurial > gemma

changeset 3631:9709081719ae configuration

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added missing insert grant to sys_admin.system_config for sys_admins.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 11 Jun 2019 12:43:05 +0200
parents 2467e619cf67
children 0e2605f6fddd
files schema/auth.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/auth.sql	Tue Jun 11 12:38:25 2019 +0200
+++ b/schema/auth.sql	Tue Jun 11 12:43:05 2019 +0200
@@ -66,7 +66,7 @@
     ON users.list_users, users.responsibility_areas TO sys_admin;
 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
-GRANT UPDATE ON sys_admin.system_config TO sys_admin;
+GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin;
 GRANT UPDATE ON systemconf.feature_colours TO sys_admin;
 GRANT UPDATE ON sys_admin.published_services TO sys_admin;
 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin;