Re: ODBC problem - crypt.. - Mailing list pgsql-interfaces

From Cedar Cox
Subject Re: ODBC problem - crypt..
Date
Msg-id Pine.LNX.4.21.0010092332560.23306-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Re: ODBC problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ODBC problem - crypt..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
On Mon, 9 Oct 2000, Tom Lane wrote:
..
> We have talked about adding a higher-security login protocol --- you can
> find past threads about this in the pghackers archive.  IIRC a fairly
> complete design was worked out, but no one's got round to implementing
> it yet.  There might still have been some unresolved objections, too.
> 
>             regards, tom lane

Perhaps I didn't make my point clear:  The only point of a password is to
protect something.  If that something is transmitted in the clear, then
from a hackers point of view there's almost no point in having a password.  
Of course this only applies to fetching data.. updates are a different
story.

So.  If working with sensitive data, shouldn't the data be encrypted as
well, not just the login sequence?  Is ssh a good way to go (assuming you 
have an account on the PG machine), and is what I proposed possible?

-Cedar



pgsql-interfaces by date:

Previous
From: "W. van den Akker"
Date:
Subject: 16-bit ODBC driver
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] JDBC Patch