Mercurial > gemma
diff schema/auth.sql @ 4236:27ed6f709195
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 |
line wrap: on
line diff
--- a/schema/auth.sql Wed Aug 21 15:59:15 2019 +0200 +++ b/schema/auth.sql Wed Aug 21 16:17:46 2019 +0200 @@ -25,10 +25,9 @@ -- -- Privileges for waterway_user -- -GRANT USAGE ON SCHEMA public, users, waterway, systemconf, sys_admin, caching TO waterway_user; +GRANT USAGE ON SCHEMA public, users, waterway, sys_admin, caching TO waterway_user; GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user; GRANT SELECT, UPDATE, DELETE, INSERT ON ALL TABLES IN SCHEMA caching TO waterway_user; -GRANT SELECT ON systemconf.feature_colours TO waterway_user; GRANT SELECT ON sys_admin.system_config TO waterway_user; GRANT UPDATE (pw, map_extent, email_address) ON users.list_users TO waterway_user; @@ -61,7 +60,6 @@ GRANT USAGE ON SCHEMA sys_admin TO sys_admin; GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; -GRANT UPDATE ON systemconf.feature_colours TO sys_admin; GRANT UPDATE ON sys_admin.published_services TO sys_admin; GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;