Re: Password sub-process ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Password sub-process ...
Date: 2002-07-26 15:48:01
Message-ID: 25887.1027698481@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rod Taylor <rbt(at)zort(dot)ca> writes:
> This still doesn't allow john on db1 to be a different user than john on
> db2. To accomplish that (easily) we still need to install different
> instances for each database.

Some people think that cross-database user names are a feature, not
a bug. I cannot see any way to change that without creating huge
backward-compatibility headaches --- and it's not at all clear to
me that it's a step forward, anyway.

I think that it might be worth adding a CONNECT privilege at the
database level; that together with Bruce's recent revisions to
pg_hba.conf ought to be a pretty good improvement.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-07-26 16:45:42 Re: Password sub-process ...
Previous Message Tom Lane 2002-07-26 15:43:37 Re: Oracle Decode Function