From e4dc6c96dc1f7838babb2f7878f196eed19a1f43 Mon Sep 17 00:00:00 2001 From: Roland Hieber Date: Thu, 22 Oct 2009 21:19:46 +0200 Subject: [PATCH] since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights, results in warning --- sql/mod_room-reservation.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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; + -- 2.20.1