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
pgpIufFmeRhCi.pgp
Description: PGP signature
