From: Silvana Di Martino <silvanadimartino@tin.it>
To: Matt Clark <matt@ymogen.net>
To: Dave Ewart <Dave.Ewart@cancer.org.uk>
To: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Fri, 5 Mar 2004 20:29:47 +0000
Message-ID: <200403051919.51117.silvanadimartino@tin.it> (raw)
In-Reply-To: <OAEAKHEHCMLBLIDGAFELIEKOEOAA.matt@ymogen.net>
References: <OAEAKHEHCMLBLIDGAFELIEKOEOAA.matt@ymogen.net>
Alle 11:17, venerdì 5 marzo 2004, Matt Clark ha scritto:
> Yes, but only if the password has to entered manually [1] at boot time.
> And it gives zero protection against someone who gains root access to the
> server.
This is a problem for italian users because the italian law clearly states
that only the people delegated to perform maintenance on the personal data
can have access to them. SysAdmin are clearly escluded. So, we do have to
protect the data even from the "prying eyes" of our SysAdmin... :-(
> So you _also_ have to encrypt the sensitive data before giving it to the
> DB, using a key that is not stored on the DB server.
Right.
> Of course that means your app servers have to have _those_ passwords/
> keys entered manually at boot time, or else someone who roots them can
> read your sensitive data quite trivially.
Right.
> And to do any better than that you need one of those very snazzy cards
> from nCipher or whoever, that allow you to process encrypted data in a
> hardware sandbox so even your application doesn't see it, or at least
> only allow signed code to manipulate the data.
Actually, we are considering the adoption of USB cryptographic keys for this
task. Having the passwords stored in a USB EPROM should be safer and easier
to use than a set of hard-to-remember/hard-to-crack alphanumeric passwords
(each at least 8 characters long, accordingly with our law).
IMHO, this crypto topic should be seriously taken into account by the
developers of all of the major Open Source Database Engines (PostgreSQL,
MySQL and Firebird). Given that a large part of the data stored into these DB
are somehow "personal" or even "sensitive", the lack of built-in
cryptographic protection could push our beloved GPL RDBMS out of the market.
See you
-----------------------------------------
Alessandro Bottoni and Silvana Di Martino
alessandrobottoni@interfree.it
silvanadimartino@tin.it
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, matt@ymogen.net, Dave.Ewart@cancer.org.uk
Subject: Re: Database Encryption (now required by law in Italy)
In-Reply-To: <200403051919.51117.silvanadimartino@tin.it>
References: <OAEAKHEHCMLBLIDGAFELIEKOEOAA.matt@ymogen.net> <200403051919.51117.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