Re: Password sub-process ...

On Tue, 30 Jul 2002, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@hub.org> writes:
> > First and foremost in my mind ... how do you have two users in the system
> > with seperate passwords?  ...
> > since as soon as there are two 'bruce' users, only one can have a password
>
> Uh, we've *never* supported "two bruce users" ... users have always been
> installation-wide.  I am not sure what the notion of a database-owning
> user means if user names are not of wider scope than databases.

Sorry, you mis-understand here ... pg_user/shadow only has one bruce user
in it ... but the way it was up until now, with the password file in
pg_hba.conf, I could assign bruce with a different password for database1
vs database2 ... effectively, have 'two bruce users' ...