Mercurial > gemma

comparison schema/auth.sql @ 5111:90b0a14dd58b queued-stage-done

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Enable jobs to be removed by the import queue.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 25 Mar 2020 16:51:45 +0100
parents 4c658a8f34da
children 18969a4d31b6
comparison
equal deleted inserted replaced
5110:4dc2e6dc6c7d 5111:90b0a14dd58b
59 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; 59 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
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 65
65 -- 66 --
66 -- Privileges assigned directly to metamorph 67 -- Privileges assigned directly to metamorph
67 -- 68 --
68 -- Needed for GeoServer's system inspection run before session startup SQL 69 -- Needed for GeoServer's system inspection run before session startup SQL