Re: [otrs] trying to get OTRS 3 up with Postgres: bin/otrs.CheckDB.pl fails: permission denied for relation valid, SQL: 'SELECT * FROM valid'

On Tue, Mar 29, 2011 at 7:44 PM, Gerald Young wrote:

Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM valid'

... you don't have select privileges on the table named "valid" so you should grant select on valid to public;

Thanks, Gerald, that did it! Perhaps this should be added to the README.database file in the otrs source tarball. I've opened bug 7144 about it. http://bugs.otrs.org/show_bug.cgi?id=7144 Cheers, Aleksey