Re: Granting permission to root.

On 24 Jul 2002, montfort wrote:

> How can I grant permission to root so that the root user can create
> and drop databases?

From a UNIX/Linux command prompt as root

su - postgres
createuser --createdb --adduser root

From a psql prompt logged in as postgres to template1

CREATE USER root CREATEDB CREATEUSER;

Other options for assigning passwords, groups and other options is
avaliable by doing

createuser -?

from the command prompt or

\h create user

from the psql prompt

Actually the best deal is to buy, both or either, Bruce's book, The
Mammoth book (O'Reilly) or check out the docs.

Rod
--
"Open Source Software - Sometimes you get more than you paid for..."