[rt-users] installing RT with PostgreSQL yields "invalid privilege type USAGE for table" error

Aleksey Tsalolikhin atsaloli.tech at gmail.com
Tue Dec 2 17:52:00 EST 2008

On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov <ruz at bestpractical.com> wrote:
> USAGE for sequences has been added in Pg 8.2. Replace "GRANT USAGE,
> SELECT, UPDATE" with "GRANT SELECT, UPDATE" in etc/acl.Pg.

Thanks, Ruslan!  that's what I did.   But now I get HTTP 500 internal
server error when I try to access my RT for the first time.

My httpd error log reads:

DBD::Pg::st execute failed: ERROR:  permission denied for relation
users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 505.
RT::Handle=HASH(0x2aea5f3f0590) couldn't execute the query 'SELECT  *
FROM Users WHERE LOWER(Name) = LOWER(?)' at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Please advise?


More information about the rt-users mailing list