pgman wrote:
: OK, I get you now. Why not ask the client to do a crypt and compare
: that to pg_shadow. [...]
You can't trust the client to do the one-way encryption, for then the
encrypted password becomes plaintext-equivalent - it defeats the
purpose. (The SMB protocol apparently suffers or suffered from a
similar flaw.)
tgl wrote:
: What this discussion seems to come down to is whether we should take a
: backward step in one area of security (security against wire-sniffing)
: to take a forward step in another (not storing plaintext passwords).
: [...]
It seems to me that the two issues are orthogonal. Authentication and
confidentiality are not mutually dependent or reinforcing, and thus
generally need separate mechanisms.
- FChE