[rakim] GRANT lines in database script

Mike Pelley mike at pelley.com
Sat Sep 27 16:14:17 PDT 2003


I noticed the rakim.sql database does not have GRANT lines to allow access
for horde.  Most other horde projects seem to have these lines and I think
they'd be useful.  The patch below does this.

Thanks!  Mike.

Index: scripts/db/rakim.sql
===================================================================
RCS file: /usr/cvsroot/horde/rakim/scripts/db/rakim.sql,v
retrieving revision 1.18
diff -u -r1.18 rakim.sql
--- scripts/db/rakim.sql        23 Apr 2003 19:25:22 -0000      1.18
+++ scripts/db/rakim.sql        27 Sep 2003 23:05:48 -0000
@@ -196,3 +196,17 @@

     PRIMARY KEY (response_id)
 );
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_support_personnel TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_guests TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_queues TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_organizations TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_messages TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_personnel_messages TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_canned_messages TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_emails TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_email_responses TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_archived_sessions TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_archived_transcripts TO
horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_archived_emails TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON rakim_archived_email_responses TO
horde;



More information about the rakim mailing list