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; 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? -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R59. Free WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails Phone Now! 086 11 11 440