From: Roland Hieber <devnull@localhost>
Date: Thu, 22 Oct 2009 19:19:46 +0000 (+0200)
Subject: since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights... 
X-Git-Tag: REL_9.10.23~2^2~6
X-Git-Url: https://git.rohieb.name/iserv-mod-room-reservation.git/commitdiff_plain/e4dc6c96dc1f7838babb2f7878f196eed19a1f43

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

diff --git a/sql/mod_room-reservation.sql b/sql/mod_room-reservation.sql
index 436512a..796a6f7 100644
--- a/sql/mod_room-reservation.sql
+++ b/sql/mod_room-reservation.sql
@@ -32,7 +32,8 @@ CREATE TABLE mod_roomreservation_bookings (
 --
 -- Permissions
 --
-GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_bookings, mod_roomreservation_bookings_rrb_uid_seq TO webusr;
-GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_bookings, mod_roomreservation_bookings_rrb_uid_seq TO webadm;
+GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_bookings TO webusr, webadm;
+GRANT SELECT, UPDATE ON mod_roomreservation_bookings_rrb_uid_seq TO webusr, webadm;
 GRANT SELECT ON mod_roomreservation_roomswhitelist TO webusr;
 GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_roomswhitelist TO webadm;
+