Re: Password sub-process ...

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Password sub-process ...
Date: 2002-07-30 05:01:54
Message-ID: 20020730020049.N3083-100000@mail1.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 30 Jul 2002, Tom Lane wrote:

> "Marc G. Fournier" <scrappy(at)hub(dot)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' ...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-07-30 05:03:28 Re: Password sub-process ...
Previous Message Bruce Momjian 2002-07-30 04:56:53 Re: WAL file location