Re: Creating a DB for another user (or...) (repost attempt)

From: Matthew Rice <matt(at)starnix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating a DB for another user (or...) (repost attempt)
Date: 2000-08-25 18:18:23
Message-ID: 200008251818.OAA00994@hudson.starnix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > Is there a way to either assign superuser priviledges/ownership
> > to that user or to create the database for him?
>
> alter user "name" createdb;

Are you certain? From the 6.5 docs it says that this will:

Give a user the ability to create new databases

Are you saying that I temporarily let the user create dbs, create the
db and the remove the ability to create dbs?

BTW, this isn't a system user so how would he run createdb?

Regards,
--
matthew rice <matt(at)starnix(dot)com> starnix inc.
tollfree: 1-87-pro-linux thornhill, ontario, canada
http://www.starnix.com professional linux services & products

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin A. Marques 2000-08-25 18:30:31 Re: alter table and constraints
Previous Message Mike Sears 2000-08-25 17:46:50 system catalog problems