Re: [otrs] Creating a postgres database

[peter McGregor]

On Friday, February 27, 2004, at 05:01  AM, [EMAIL PROTECTED] 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

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/