Re: [PATCH] user mapping extension to pg_ident.conf - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] user mapping extension to pg_ident.conf
Date
Msg-id 18190.1248267227@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] user mapping extension to pg_ident.conf  (Magnus Hagander <magnus@hagander.net>)
Responses Re: [PATCH] user mapping extension to pg_ident.conf  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
>> Yup, you would need a protocol change that would allow the client to
>> change its mind about what the username was after it got the auth
>> challenge. �And then what effects does that have on username-sensitive
>> pg_hba.conf decisions? �We go back and change our minds about the
>> challenge type, perhaps? �The whole thing seems like a nonstarter to me.

> "challenge type"? Not sure I understand what you are referring to here.

The point is that pg_hba.conf allows the selection of auth method to
depend on username.  What happens if, after being told auth method is
(say) Kerberos, the client comes back and wants to use a different
username that should have resulted in a different auth method according
to pg_hba.conf?  It's not hard to construct scenarios where that would
be seen as a security breach.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Upgrading our minimum required flex version for 8.5
Next
From: Magnus Hagander
Date:
Subject: Re: [PATCH] user mapping extension to pg_ident.conf