On Saturday, February 28, 2004, at 03:29 AM, henry@metroweb.co.za wrote:
On Friday, February 27, 2004, at 05:01 AM, henry@metroweb.co.za wrote:
once the DB is created, login with user postgres and execute:
grant all on database otrs to otrs;
Thanks for the tip. I tried this command but its a postgres 7.3 command, not a 7.2 command
how about: grant all on otrs to otrs;
It complains about relation otrs not found
I'm not sure what the behaviour of 7.2 is, but I tested the situation with 7.4 and it allowed user otrs to create tables, etc. ie, default permission was open for the newly created 'otrs' db.
Is upgrading to 7.4.x out of the question?
I tried upgrading some time ago to postgres 7.3, but from what I can remember the rpm's wouldn't insert because of dependencies in Redhat 7.3 We might try putting another box in though. Thanks for your help Peter McGregor