From 393e13cb503927e58d0b34923aaa71c064417f9c Mon Sep 17 00:00:00 2001 From: Roland Hieber Date: Fri, 23 Oct 2009 01:48:59 +0200 Subject: [PATCH] since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights, results in warning --- sql/mod_error-reporter.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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; + -- 2.20.1