Re: Database Encryption (now required by law in Italy) - Mailing list pgsql-admin

From Mitch Pirtle
Subject Re: Database Encryption (now required by law in Italy)
Date
Msg-id 40488640.1040409@spacemonkeylabs.com
Whole thread Raw
In response to Re: Database Encryption (now required by law in Italy)  (Dave Ewart <Dave.Ewart@cancer.org.uk>)
Responses Re: Database Encryption (now required by law in Italy)  (Matt Davies <matt@mattdavies.net>)
Re: Database Encryption (now required by law in Italy)  (Alex Page <alex.page@cancer.org.uk>)
Re: Database Encryption (now required by law in Italy)  (Radu-Adrian Popescu <radu.popescu@aldratech.com>)
Re: Database Encryption (now required by law in Italy)  (Silvana Di Martino <silvanadimartino@tin.it>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Mark Gibson
Date:
Subject: Re: Database Encryption (now required by law in Italy)
Next
From: Dave Ewart
Date:
Subject: Re: Database Encryption (now required by law in Italy)