Re: Password sub-process ...

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom Lane wrote:
> >> Uh, we've *never* supported "two bruce users" ...
> 
> > He was being tricky by having different passwords for the same user on
> > each database, so one user couldn't get into the other database, even
> > though it was the same name.
> 
> But the system didn't realize they were two different users.  (Try
> dropping just one of them.)  And what if they happened to choose the
> same password?  I think this is a fragile kluge not a supported feature.
> 
> > The question is whether using those secondary
> > passwords is widespread enough that I need to get that into the code
> > too.  It was pretty confusing for users, so I am hesitant to re-add it,
> > but I hate for Marc to lose functionality he had in the past.
> 
> I'd like to think of a better answer, not put back that same kluge.
> Ideas anyone?

I just thought a little more.  Basically, I can't imagine any better
answer because they _should_ be the same user, and any trickery that
allows the same user to have two different passwords for two different
database will appear to be bad design.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026