Mercurial > gemma

diff schema/auth.sql @ 327:363983d5c567

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow Waterway User to update a limited set of profile attributes
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Aug 2018 19:25:30 +0200
parents e4bf72cda62e
children b97b3172c61a
line wrap: on
line diff
--- a/schema/auth.sql	Thu Aug 02 18:39:01 2018 +0200
+++ b/schema/auth.sql	Thu Aug 02 19:25:30 2018 +0200
@@ -12,6 +12,8 @@
 --
 GRANT USAGE ON SCHEMA public, users, waterway TO waterway_user;
 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;
+GRANT UPDATE (pw, map_extent, email_address) ON users.list_users
+    TO waterway_user;
 
 --
 -- Extended privileges for waterway_admin