Re: Password sub-process ...

Rod Taylor <rbt@zort.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