Mercurial > gemma

changeset 5645:6fe970d800ec DQR adjustments

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjust access rights
author Thomas Junk <thomas.junk@intevation.de>
date Mon, 19 Jun 2023 12:46:57 +0200
parents f432f578d7e7
children 88fdf143daf1
files schema/updates/1470/01.update_report.sql
diffstat 1 files changed, 4 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1470/01.update_report.sql	Wed Jun 14 10:14:43 2023 +0200
+++ b/schema/updates/1470/01.update_report.sql	Mon Jun 19 12:46:57 2023 +0200
@@ -27,4 +27,7 @@
          AND d.ym <= efa.measure_date
          AND efa.measure_date < (d.ym + interval '1 month')
          AND efa.measure_type = 'Measured'
-    GROUP BY bn.cc, bn.hm, d.ym, bn.bottleneck_id, bn.objnam;
\ No newline at end of file
+    GROUP BY bn.cc, bn.hm, d.ym, bn.bottleneck_id, bn.objnam;
+
+-- Refresh access rights!
+GRANT SELECT on ALL tables in schema waterway TO waterway_user;
\ No newline at end of file