diff schema/auth.sql @ 840:0f61bfc21041

Added end point to get style (colour) information for feature.
author Sascha Wilde <wilde@intevation.de>
date Fri, 28 Sep 2018 10:56:03 +0200
parents ea0eb6ef98ce
children 6902032757e4
line wrap: on
line diff
--- a/schema/auth.sql	Fri Sep 28 10:46:01 2018 +0200
+++ b/schema/auth.sql	Fri Sep 28 10:56:03 2018 +0200
@@ -10,8 +10,9 @@
 --
 -- Privileges for waterway_user
 --
-GRANT USAGE ON SCHEMA public, users, waterway TO waterway_user;
+GRANT USAGE ON SCHEMA public, users, waterway, systemconf TO waterway_user;
 GRANT SELECT ON ALL TABLES IN SCHEMA public, users, waterway TO waterway_user;
+GRANT SELECT ON systemconf.feature_colours TO waterway_user;
 GRANT UPDATE (pw, map_extent, email_address) ON users.list_users
     TO waterway_user;