# HG changeset patch # User Sascha L. Teichmann # Date 1560249785 -7200 # Node ID 9709081719ae9d1b77baeba179d9bb395a57783c # Parent 2467e619cf676a8578de286209a729849cb954dc Added missing insert grant to sys_admin.system_config for sys_admins. diff -r 2467e619cf67 -r 9709081719ae schema/auth.sql --- 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;