Mercurial > gemma

comparison schema/auth.sql @ 5384:18969a4d31b6 extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added a table to store SQL update scripts for aggregated data.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 01 Jul 2021 21:56:50 +0200
parents 90b0a14dd58b
children 7f5fc8ece589
comparison
equal deleted inserted replaced
5383:d61aab631d65 5384:18969a4d31b6
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 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