pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Pirtle <mitchy@spacemonkeylabs.com>
To: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Fri, 05 Mar 2004 08:53:04 -0500
Message-ID: <40488640.1040409@spacemonkeylabs.com> (raw)
In-Reply-To: <20040305121254.GK13042@nemesis.ox.icnet.uk>
References: <200403050951.33230.silvanadimartino@tin.it>
	<40484403.70001@aldratech.com>
	<200403051245.10681.silvanadimartino@tin.it>
	<20040305121254.GK13042@nemesis.ox.icnet.uk>

Dave Ewart wrote:

> If you find any 'automated' front-end to do this at the database-level,
> rather than something like loopback at the filesystem level or at the
> field level for specific fields, I think there would be a lot of
> interest.

But that is the problem, isn't it?  Any 'automated' 
encryption/decryption will be just as useful to the would-be perpetrator 
of data theft.  This is like having an automatic alarm system on your 
car that works for anyone that walks up to it.

The same logic applies to encrypting the data in the database - 
somewhere on your server the application has to know how to decrypt it, 
and that means anyone that gains access to your server will have that 
ability also...

I understand (and demand) requiring SSL connections for database 
clients, and MD5 hashing of passwords before storing in the database, 
but implementing two-way encryption of database data just doesn't make 
sense to me.

-- Mitch



view thread (65+ messages)  latest in thread

Message-ID: <40488640.1040409@spacemonkeylabs.com>
Permalink:  ../40488640.1040409@spacemonkeylabs.com/
Also on:    postgresql.org/message-id/40488640.1040409@spacemonkeylabs.com

 · 

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: mitchy@spacemonkeylabs.com
  Subject: Re: Database Encryption (now required by law in Italy)
  In-Reply-To: <40488640.1040409@spacemonkeylabs.com>
  References: <200403050951.33230.silvanadimartino@tin.it> <40484403.70001@aldratech.com> <200403051245.10681.silvanadimartino@tin.it> <20040305121254.GK13042@nemesis.ox.icnet.uk> <40488640.1040409@spacemonkeylabs.com>

* 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