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

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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Murray Cumming <murrayc(at)murrayc(dot)com>
Cc: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: per-database groups? (was Discovering privileges)
Date: 2005-03-21 21:13:39
Message-ID: 20050321211339.GA43088@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

pgsql-interfaces by date

Next:From: Murray CummingDate: 2005-03-21 21:17:12
Subject: Re: per-database groups? (was Discovering privileges)
Previous:From: Murray CummingDate: 2005-03-21 18:38:00
Subject: per-database groups? (was Discovering privileges)

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