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..."
