From: Roland Hieber <devnull@localhost>
Date: Thu, 22 Oct 2009 23:48:59 +0000 (+0200)
Subject: since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights... 
X-Git-Tag: REL_9.10.23~7
X-Git-Url: https://git.rohieb.name/iserv-mod-error-reporter.git/commitdiff_plain/393e13cb503927e58d0b34923aaa71c064417f9c

since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights, results in warning
---

diff --git a/sql/mod_error-reporter.sql b/sql/mod_error-reporter.sql
index 0e3ea56..00ebb91 100644
--- a/sql/mod_error-reporter.sql
+++ b/sql/mod_error-reporter.sql
@@ -40,5 +40,6 @@ CREATE TABLE mod_errorreporter (
   er_hidden       BOOL
 );
 
-GRANT SELECT, INSERT, UPDATE, DELETE ON mod_errorreporter, mod_errorreporter_er_uid_seq TO webadm;
-GRANT SELECT, INSERT, UPDATE, DELETE ON mod_errorreporter, mod_errorreporter_er_uid_seq TO webusr;
+GRANT SELECT, INSERT, UPDATE, DELETE ON mod_errorreporter TO webusr, webadm;
+GRANT SELECT, UPDATE ON mod_errorreporter_er_uid_seq TO webusr, webadm;
+