On Thu, Nov 21, 2002 at 13:16:50 -0500,
Dan MacNeil <dan(at)ltc(dot)org> wrote:
>
> Right now we give a user full privledges to the database, named after
> the user by
>
> 1) creating the user with CREATEDB
> 2) Give the user the right to connect to the database dummy
> 3) creating a database as that user
> 4) taking away the users rights to CREATEDB
>
> Is there a less kludgy way?
In 7.3:
CREATEDB DATABASE dbname OWNER username