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 === postgres 7.2 help === otrs=# \h grant Command: GRANT Description: define access privileges Syntax: GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] objectname [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] otrs=# === Thanks Peter