[rt-users] postgres permission denied

[Kevin Falcone]

On Wed, Jan 29, 2014 at 05:39:00PM +0000, Thomas Krichel wrote:
> postgres=# grant all on database rtdb to rtuser;
> GRANT
> postgres=# ALTER DEFAULT PRIVILEGES GRANT ALL ON TABLES TO rtuser;
> ALTER DEFAULT PRIVILEGES

These don't seem like they would touch sequences.

I'd be inspecting the output of \z topics, and \z on the sequences
that are affected.

Also - connecting as the rtuser may be insufficient to fix
permissions.  I suspect you actually need to run the acl fixes in RT
as the postgres user.

The debian packages may have a way to rerun what was done during
install, but I don't know it off the top of my head.

Once you figure this out, I suggest considering using the
debian-backports repo to get a version of RT from 2013 not 2012.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140129/b1cab019/attachment.sig>