From ef9855e3023558132b4669319335782b5dd2ff6d Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 30 Mar 2011 16:57:41 +0000
Subject: [PATCH] add rt tables to pg-readonly, RT#10536

---
 bin/pg-readonly | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

diff --git a/bin/pg-readonly b/bin/pg-readonly
index ad69fbde2..091174cff 100644
--- a/bin/pg-readonly
+++ b/bin/pg-readonly
@@ -22,3 +22,34 @@ foreach my $table ( dbdef->tables ) {
     $dbh->commit();
   }
 }
+
+my @rt_tables = qw(
+Attachments
+Queues
+Links
+Principals
+Groups
+ScripConditions
+Transactions
+Scrips
+ACL
+GroupMembers
+CachedGroupMembers
+Users
+Tickets
+ScripActions
+Templates
+ObjectCustomFieldValues
+CustomFields
+ObjectCustomFields
+CustomFieldValues
+Attributes
+sessions
+);
+
+foreach my $rt_table ( @rt_tables ) {
+  $dbh->do("GRANT SELECT ON $table TO $rouser");
+  $dbh->commit();
+  $dbh->do("GRANT SELECT ON ${table}_id_seq TO $rouser");
+  $dbh->commit();
+}
-- 
2.11.0