[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