pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Silvana Di Martino <silvanadimartino@tin.it>
To: Joe Conway <mail@joeconway.com>
Cc: Peter Galbavy <peter.galbavy@knowtion.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Mon, 8 Mar 2004 22:43:37 +0000
Message-ID: <200403082219.06167.silvanadimartino@tin.it> (raw)
In-Reply-To: <404CAD5D.6010503@joeconway.com>
References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is>
	<200403081226.10550.silvanadimartino@tin.it>
	<404CAD5D.6010503@joeconway.com>

Alle 17:29, lunedì 8 marzo 2004, Joe Conway ha scritto:
> Silvana Di Martino wrote:
> > Oracle has a built-in feature for encrypting/decrypting this password's
> > password.
>
> Right, and this master password is only protected because Oracle is
> closed source. It is not possible to do the same thing with Postgres
> because you could find the master key (or the algorithm to produce it)
> in the source code.
>
> However this amounts to "security by obscurity", and anyone serious
> about encryption will tell you it is insufficient. There is no way to
> have cryptographically sound protection of your data using a key
> embedded in the software like that.

Right. I completely agree. The only way to implement such a mechanism in a 
open source product is to keep the password away from the RDBMS host. See my 
previous messages for a plausible scenario.

See you

-----------------------------------------
Alessandro Bottoni and Silvana Di Martino
alessandrobottoni@interfree.it
silvanadimartino@tin.it



view thread (65+ messages)  latest in thread

Message-ID: <200403082219.06167.silvanadimartino@tin.it>
Permalink:  ../200403082219.06167.silvanadimartino@tin.it/
Also on:    postgresql.org/message-id/200403082219.06167.silvanadimartino@tin.it

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: silvanadimartino@tin.it, mail@joeconway.com, peter.galbavy@knowtion.net
  Subject: Re: Database Encryption (now required by law in Italy)
  In-Reply-To: <200403082219.06167.silvanadimartino@tin.it>
  References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403081226.10550.silvanadimartino@tin.it> <404CAD5D.6010503@joeconway.com> <200403082219.06167.silvanadimartino@tin.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox