comparison schema/auth.sql @ 5399:47c2ca05e8ec

Merged extented-report branch back into default.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 07 Jul 2021 11:44:40 +0200
parents 7f5fc8ece589
children a30b6c6541e0
comparison
equal deleted inserted replaced
5319:4a6feb5d3727 5399:47c2ca05e8ec
60 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; 60 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
61 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; 61 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin;
62 GRANT UPDATE ON sys_admin.published_services TO sys_admin; 62 GRANT UPDATE ON sys_admin.published_services TO sys_admin;
63 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; 63 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;
64 GRANT DELETE ON import.imports, import.import_logs TO sys_admin; 64 GRANT DELETE ON import.imports, import.import_logs TO sys_admin;
65 GRANT SELECT, INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin;
65 66
66 -- 67 --
67 -- Privileges assigned directly to metamorph 68 -- Privileges assigned directly to metamorph
68 -- 69 --
69 -- Needed for GeoServer's system inspection run before session startup SQL 70 -- Needed for GeoServer's system inspection run before session startup SQL