
falcone at bestpractical
Nov 19, 2009, 8:35 AM
Post #1 of 1
(314 views)
Permalink
|
|
rtfm branch, master, updated. b0ee811c4fe124d4c13e4d42c3ada84f10de4883
|
|
The branch, master has been updated via b0ee811c4fe124d4c13e4d42c3ada84f10de4883 (commit) from ffed7e936b4c451577db2cfbdf834ee5c725a480 (commit) Summary of changes: etc/acl.Pg | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) - Log ----------------------------------------------------------------- commit b0ee811c4fe124d4c13e4d42c3ada84f10de4883 Author: Dominic Hargreaves <dom [at] earth> Date: Thu Nov 19 11:07:23 2009 -0500 Fix Postgres ACL script to work with usernames that need quoting diff --git a/etc/acl.Pg b/etc/acl.Pg index 7fa81ca..62d1e77 100644 --- a/etc/acl.Pg +++ b/etc/acl.Pg @@ -22,9 +22,9 @@ FM_ObjectTopics : "SELECT, UPDATE"; foreach my $table (@tables) { if ( $table =~ /id_seq$/ ) { - push @acls, "GRANT $sequence_right ON $table TO $RT::DatabaseUser;"; + push @acls, "GRANT $sequence_right ON $table TO \"$RT::DatabaseUser\";"; } else { - push @acls, "GRANT SELECT, INSERT, UPDATE, DELETE ON $table to $RT::DatabaseUser;"; + push @acls, "GRANT SELECT, INSERT, UPDATE, DELETE ON $table to \"$RT::DatabaseUser\";"; } } return (@acls); ----------------------------------------------------------------------- _______________________________________________ Rt-commit mailing list Rt-commit [at] lists http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-commit
|