Mercurial > gemma

comparison schema/auth.sql @ 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 73fd4dd9e569
children db87f34805fb
comparison
equal deleted inserted replaced
3630:2467e619cf67 3631:9709081719ae
64 -- 64 --
65 GRANT INSERT, UPDATE, DELETE 65 GRANT INSERT, UPDATE, DELETE
66 ON users.list_users, users.responsibility_areas TO sys_admin; 66 ON users.list_users, users.responsibility_areas TO sys_admin;
67 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; 67 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
68 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; 68 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
69 GRANT UPDATE ON sys_admin.system_config TO sys_admin; 69 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin;
70 GRANT UPDATE ON systemconf.feature_colours TO sys_admin; 70 GRANT UPDATE ON systemconf.feature_colours TO sys_admin;
71 GRANT UPDATE ON sys_admin.published_services TO sys_admin; 71 GRANT UPDATE ON sys_admin.published_services TO sys_admin;
72 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin; 72 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin;
73 73
74 -- 74 --