Mercurial > gemma

comparison schema/auth.sql @ 4236:27ed6f709195

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove unused systemconf.feature_colours from backend * Remove unused routes for `/system/style/{feature}/{attr}`, including the namespace `systemconf` from the schema. This has previously be replaced by a more general mechanism, which is already used by the frontend.
author Bernhard Reiter <bernhard@intevation.de>
date Wed, 21 Aug 2019 16:17:46 +0200
parents 64cd18281c76
children 5e38667f740c
comparison
equal deleted inserted replaced
4235:966d7eb6d99b 4236:27ed6f709195
23 REVOKE ALL ON SCHEMA public FROM PUBLIC; 23 REVOKE ALL ON SCHEMA public FROM PUBLIC;
24 24
25 -- 25 --
26 -- Privileges for waterway_user 26 -- Privileges for waterway_user
27 -- 27 --
28 GRANT USAGE ON SCHEMA public, users, waterway, systemconf, sys_admin, caching TO waterway_user; 28 GRANT USAGE ON SCHEMA public, users, waterway, sys_admin, caching TO waterway_user;
29 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user; 29 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;
30 GRANT SELECT, UPDATE, DELETE, INSERT ON ALL TABLES IN SCHEMA caching TO waterway_user; 30 GRANT SELECT, UPDATE, DELETE, INSERT ON ALL TABLES IN SCHEMA caching TO waterway_user;
31 GRANT SELECT ON systemconf.feature_colours TO waterway_user;
32 GRANT SELECT ON sys_admin.system_config TO waterway_user; 31 GRANT SELECT ON sys_admin.system_config TO waterway_user;
33 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users 32 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users
34 TO waterway_user; 33 TO waterway_user;
35 34
36 -- 35 --
59 GRANT INSERT, UPDATE, DELETE 58 GRANT INSERT, UPDATE, DELETE
60 ON users.list_users, users.responsibility_areas TO sys_admin; 59 ON users.list_users, users.responsibility_areas TO sys_admin;
61 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; 60 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
62 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; 61 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
63 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; 62 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin;
64 GRANT UPDATE ON systemconf.feature_colours TO sys_admin;
65 GRANT UPDATE ON sys_admin.published_services TO sys_admin; 63 GRANT UPDATE ON sys_admin.published_services TO sys_admin;
66 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; 64 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;
67 65
68 -- 66 --
69 -- Privileges assigned directly to metamorph 67 -- Privileges assigned directly to metamorph