since postgresql-8.3, sequences are not allowed to have INSERT and DELETE rights...
authorRoland Hieber <devnull@localhost>
Thu, 22 Oct 2009 19:19:46 +0000 (21:19 +0200)
committerRoland Hieber <devnull@localhost>
Thu, 22 Oct 2009 19:19:46 +0000 (21:19 +0200)
sql/mod_room-reservation.sql

index 436512a..796a6f7 100644 (file)
@@ -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;
+
This page took 0.026626 seconds and 4 git commands to generate.