RE: User Management

Chris Cameron <chris@upnix.com>

From: "Chris Cameron" <chris@UpNIX.com>
To: "D. Duccini" <duccini@backpack.com>
Cc: <pgsql-novice@postgresql.org>
Date: 2001-07-04T23:02:10Z
Lists: pgsql-novice
That doesn't solve my problem of whoever creates the database owns the
database.

I'd like to have user 'joe' have access /only/ to the database 'chris'.
As far as I can tell the only way to do this is have 'joe' create the
database.

I'm looking for the equivalent to 'GRANT ALL ON chris to joe@localhost
identified by 'joepass';' in MySQL.

Chris

-----Original Message-----
From: D. Duccini [mailto:duccini@backpack.com]
Sent: Wednesday, July 04, 2001 4:48 PM
To: Chris Cameron
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] User Management



use the "createuser" command