# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1528922378 -7200
# Node ID 81a2b26bf16bb3fd16c35407b54b0e389e96f201
# Parent  9c2b796d506f39f8af3dfda274e6cda19deb6734
SELECT privilege on a table is useless without USAGE on the schema.

diff -r 9c2b796d506f -r 81a2b26bf16b auth.sql
--- a/auth.sql	Fri Jun 08 12:43:57 2018 +0200
+++ b/auth.sql	Wed Jun 13 22:39:38 2018 +0200
@@ -18,7 +18,7 @@
 --
 -- Privileges for waterway_user
 --
-GRANT USAGE ON SCHEMA wamos_waterway, wamos_fairway TO waterway_user;
+GRANT USAGE ON SCHEMA wamos, wamos_waterway, wamos_fairway TO waterway_user;
 GRANT SELECT ON ALL TABLES IN SCHEMA wamos_waterway, wamos_fairway
       TO waterway_user;
 GRANT SELECT ON templates, user_profiles TO waterway_user;