On Thu, Nov 21, 2002 at 13:16:50 -0500, Dan MacNeil <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster