Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating a DB for another user (or...) (repost attempt) - Mailing list pgsql-general

From Matthew Rice
Subject Re: Creating a DB for another user (or...) (repost attempt)
Date
Msg-id 200008251818.OAA00994@hudson.starnix.com
Whole thread Raw
In response to Creating a DB for another user (or...) (repost attempt)  (Matthew Rice <matt@starnix.com>)
Responses Re: Creating a DB for another user (or...) (repost attempt)  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-general
Tree view 
> > 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@starnix.com>                               starnix inc.
tollfree: 1-87-pro-linux                        thornhill, ontario, canada
http://www.starnix.com              professional linux services & products

pgsql-general by date:

Previous
From: "Mike Sears"
Date:
Subject: system catalog problems
Next
From: "Martin A. Marques"
Date:
Subject: Re: alter table and constraints