Skip site navigation (1) Skip section navigation (2)

Re: per-database groups? (was Discovering privileges)

From: Murray Cumming <murrayc(at)murrayc(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: per-database groups? (was Discovering privileges)
Date: 2005-03-21 21:17:12
Message-ID: 1111439833.5554.61.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Mon, 2005-03-21 at 14:13 -0700, Michael Fuhr wrote:
> On Mon, Mar 21, 2005 at 07:38:00PM +0100, Murray Cumming wrote:
> 
> > I notice that users and groups are per-cluster rather than per-database.
> > Is there any way to create users and groups that are not available to
> > other databases on the same cluster?
> 
> What do you mean by "available"?  You can use pg_hba.conf to control
> which users can connect to which databases, if that's what you're
> after.  Or maybe db_user_namespace will do what you want:
> 
> http://www.postgresql.org/docs/8.0/interactive/runtime-config.html#GUC-DB-USER-NAMESPACE

Thanks. That looks like what I want.

-- 
Murray Cumming
murrayc(at)murrayc(dot)com
www.murrayc.com
www.openismus.com


In response to

pgsql-interfaces by date

Next:From: Kathy SmithDate: 2005-03-23 19:35:12
Subject: Execute access on functions
Previous:From: Michael FuhrDate: 2005-03-21 21:13:39
Subject: Re: per-database groups? (was Discovering privileges)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group