cryptography, was Drawbacks of using BYTEA for PK?

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>, "Greg Stark" <gsstark(at)mit(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: cryptography, was Drawbacks of using BYTEA for PK?
Date: 2004-01-13 07:59:51
Message-ID: 015801c3d9b1$3a5b8120$54285e3d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Keith C. Perry" <netadmin(at)vcsn(dot)com>
> Using an MD5 hash to
> "hide" them will slow your app down by some delta and not protect your
> connection. Granted garbling that id with a password is somewhat more
secure
> but your connection could still be attacked or even hijacked.
>
> In the URL's you gave above, why are you not using HTTPS (i.e.
authentication)?
> What about using a crytographic cookies to identify your session and link
that
> to you userid (after authorization)?

Https I can see. I am having difficulty understanding how you could use
cryptographic cookies to prevent session hijacking though given the current
setup. Also you could use ssl between the web server and PostgreSQL to
secure that connection.

As a side question: Does PostgreSQL support using Kerberos for encrypted
connections (beyond authentication), or do you need to use SSL for that?

Best Wishes,
Chris Travers

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2004-01-13 08:15:52 Re: Drawbacks of using BYTEA for PK?
Previous Message Anton.Nikiforov 2004-01-13 07:55:17 Re: Hierarchical queries