Mercurial > gemma

comparison schema/auth.sql @ 5185:3c748b2b4de6 new-fwa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into new-fwa branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 27 Mar 2020 15:57:40 +0100
parents 90b0a14dd58b
children 18969a4d31b6
comparison
equal deleted inserted replaced
5184:445daeefca7b 5185:3c748b2b4de6
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