Mercurial > gemma

comparison schema/auth.sql @ 737:ea0eb6ef98ce

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Granted rights to sys_admin on waterway.sounding_results_contour_lines.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 24 Sep 2018 11:36:30 +0200
parents 3af7ca761f6a
children 0f61bfc21041
comparison
equal deleted inserted replaced
736:34ea9d5df653 737:ea0eb6ef98ce
30 ON users.list_users, users.responsibility_areas TO sys_admin; 30 ON users.list_users, users.responsibility_areas TO sys_admin;
31 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; 31 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
32 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; 32 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
33 GRANT UPDATE ON sys_admin.system_config TO sys_admin; 33 GRANT UPDATE ON sys_admin.system_config TO sys_admin;
34 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin; 34 GRANT INSERT, DELETE ON sys_admin.password_reset_requests TO sys_admin;
35 GRANT INSERT, DELETE, UPDATE ON waterway.sounding_results_contour_lines TO sys_admin;
35 36
36 -- 37 --
37 -- Privileges assigned directly to metamorph 38 -- Privileges assigned directly to metamorph
38 -- 39 --
39 -- Needed for GeoServer's system inspection run before session startup SQL 40 -- Needed for GeoServer's system inspection run before session startup SQL