--- a/schema/auth.sql	Wed Dec 19 17:59:31 2018 +0100
+++ b/schema/auth.sql	Wed Dec 19 18:12:03 2018 +0100
@@ -34,15 +34,13 @@
 --
 -- Extended privileges for waterway_admin
 --
-GRANT INSERT, UPDATE ON ALL TABLES IN SCHEMA waterway TO waterway_admin;
--- TODO: will there ever be UPDATEs or can we drop that due to historicisation?
+GRANT INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA waterway
+    TO waterway_admin;
+-- TODO: will there ever be UPDATEs and DELETEs or can we drop that for
+-- imported data due to historicisation? Special tables like
+-- import_configuration will further need UPDATE and DELETE privileges.
 GRANT INSERT, UPDATE, DELETE ON
     users.templates, users.user_templates TO waterway_admin;
-GRANT INSERT, UPDATE, DELETE ON
-    waterway.imports, waterway.import_logs, waterway.track_imports,
-    waterway.sounding_results, waterway.import_configuration,
-    waterway.bottlenecks
-    TO waterway_admin;
 
 --
 -- Extended privileges for sys_admin