From: matt@ymogen.net
To: Joe Conway <mail@joeconway.com>
Cc: Silvana Di Martino <silvanadimartino@tin.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: pgcrypto and database encryption
Date: Sun, 7 Mar 2004 22:16:44 -0000 (GMT)
Message-ID: <3195.82.68.132.233.1078697804.squirrel@webmail.ymogen.com> (raw)
In-Reply-To: <404B67C6.6030106@joeconway.com>
References: <200403071613.03397.silvanadimartino@tin.it>
<404B67C6.6030106@joeconway.com>
> Does the law require protection from a determined DBA, or just casual
> viewing by the DBA? *If* it's the latter, you could do something like
> this:
The EU directive (and therefore the laws of indiviual countries) requires
that if someone gets access to your *DATABASE* they cannot get personal
details of individuals out of it. That is all. It is intended to protect
people against the kind of idiotic organisations that put their customer
lists in an Excel sheet on their extranet without a password.
This thread has covered many interesting and diverting issues, but the
fundamental issue of legal compliance is more than satisfied by:
1) Encrypting 'personal information' stored in a DB
2) Keeping the keys on a different server than the DB
3) Making reasonable efforts [1] to keep those keys secrets
M
[1] As far as I can tell from discussions with the Data Protection
Registrar, you do not have to protect them against someone rooting the app
server (since that is essentially impossible without silly investments in
specialised hardware or other excessive costs).
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: matt@ymogen.net, mail@joeconway.com, silvanadimartino@tin.it
Subject: Re: pgcrypto and database encryption
In-Reply-To: <3195.82.68.132.233.1078697804.squirrel@webmail.ymogen.com>
References: <200403071613.03397.silvanadimartino@tin.it> <404B67C6.6030106@joeconway.com> <3195.82.68.132.233.1078697804.squirrel@webmail.ymogen.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