Mercurial > gemma
changeset 3626:73fd4dd9e569 configuration
grant read permission on system_config for waterway_users
| author | Markus Kottlaender <markus@intevation.de> |
|---|---|
| date | Fri, 07 Jun 2019 14:17:01 +0200 |
| parents | a688a478e35f |
| children | 67984bf6dba6 |
| files | schema/auth.sql |
| diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/auth.sql Fri Jun 07 12:53:41 2019 +0200 +++ b/schema/auth.sql Fri Jun 07 14:17:01 2019 +0200 @@ -25,10 +25,11 @@ -- -- Privileges for waterway_user -- -GRANT USAGE ON SCHEMA public, users, waterway, systemconf, caching TO waterway_user; +GRANT USAGE ON SCHEMA public, users, waterway, systemconf, 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;