db_user migration

[iserv-mod-room-reservation.git] / sql / mod_room-reservation.sql

diff --git a/sql/mod_room-reservation.sql b/sql/mod_room-reservation.sql
index b585798..c34f355 100644 (file)
--- a/sql/mod_room-reservation.sql
+++ b/sql/mod_room-reservation.sql
@@ -1,3 +1,5 @@
+CREATE USER roomreservation;
+
 --
 -- Table with rooms allowed for booking
 -- 
@@ -33,11 +35,15 @@ CREATE TABLE mod_roomreservation_bookings (
 --
 -- Permissions
 --
-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_bookings TO
+  roomreservation; 
+GRANT SELECT, UPDATE ON mod_roomreservation_bookings_rrb_uid_seq TO
+  roomreservation;
 GRANT SELECT, INSERT, UPDATE, DELETE ON mod_roomreservation_roomswhitelist TO
-  webadm;
-
+  roomreservation;
+GRANT INSERT, UPDATE ON log TO roomreservation;
+GRANT SELECT, INSERT, UPDATE ON log_module TO roomreservation;
+GRANT SELECT ON users TO roomreservation;
+GRANT SELECT ON groups TO roomreservation;
+GRANT SELECT ON rooms TO roomreservation;
+GRANT SELECT, INSERT ON privileges_assign TO roomreservation;