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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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