Tom Lane wrote:
> Gavin Sherry <swm@linuxworld.com.au> writes:
> > On Fri, 4 Jan 2002, Kaare Rasmussen wrote:
> >> CREATE DATABASE dbname WITH OWNER = "user"
>
> > A much better idea. There is no conflict in using OWNER here.
> > Revised patch attached.
>
> I have applied this patch, with a couple of editorial tweaks, and one
> not-so-minor change: superuser privilege is required to create a
> database on behalf of another user. Seems to me that CREATEDB
> privilege should not be sufficient to allow such an operation.
>
> Still to do: teach createdb script about it, and revise pg_dumpall
> to use the facility instead of assuming that database owners have
> CREATEDB privilege. Working on those now ...
Seems you are already on that too. I will wait for you to finish, when
there will be nothing left for me to do. :-(
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026