public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rod Taylor <[email protected]>
To: news <[email protected]>
Cc: [email protected]
Subject: Re: pgsql user creation query:
Date: 09 Sep 2002 11:21:50 -0400
Message-ID: <1031584910.268.36.camel@jester> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

In 7.2 you must create the database as the user.
CREATE USER <user> CREATEDB;
\c - <user>
CREATE DATABASE <db>;
ALTER USER <user> NOCREATEDB;

In 7.3 you can:
CREATE DATABASE <db> WITH OWNER = <user>;

On Thu, 2002-09-05 at 16:34, news wrote:
> Hi all,
> 
> I'm just starting out with pgsql, moving away from mysql as I'm missing
> having a procedural language. Anyway, I apologise if this is an easily
> resolved problem, I have looked through the docs for any answers but they
> don't seem to be coming easily.
> 
> I'm wondering if it's possible to create a user and assign that user as an
> owner of a database, so that user can do pretty much anything they wish to
> that database and any existing and to-be-created objects within it?
> 
> I hope this makes sense
> Thank you all for your time,
> Michael.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
  Rod Taylor

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgsql user creation query:
  In-Reply-To: <1031584910.268.36.camel@jester>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox