From: Silvana Di Martino <silvanadimartino@tin.it>
To: Radu-Adrian Popescu <radu.popescu@aldratech.com>
To: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Fri, 5 Mar 2004 19:27:11 +0000
Message-ID: <200403051927.11026.silvanadimartino@tin.it> (raw)
In-Reply-To: <404864DD.6000207@aldratech.com>
References: <OAEAKHEHCMLBLIDGAFELIEKOEOAA.matt@ymogen.net>
<404864DD.6000207@aldratech.com>
Alle 11:30, venerdì 5 marzo 2004, Radu-Adrian Popescu ha scritto:
> We're basically doing it this way: generate a pair of private/public
> keys and save these.
> Then we get sensitive data in from some outside source, use it in the
> processing part,
> then we encrypt it using the public key (obviously) and store it in
> the database. They
> public key lives itself inside the database, because it presents no
> security risk if exposed.
> The private key lives on a separate machine in another physical
> location. So no-one can
> decrypt the data even if gaining access to the server machines.
> Obviously this assumes
> that we do not decrypt the data after using it... Which is something
> rather hard to enforce,
> depending on the application.
>
> If we do need to decrypt the data, we take the encrypted data to a
> safe location, get the private key
> securely and then decrypt and use the data.
That is quite complicated. It looks like what we actually need is a system
like Kerberos (devoted to data encryption "on the fly" instead of user
authentication). The logical schema of Kerberos fits well our model: a
third-party system authenticate and authorize whoever (process or human) that
have to access the data. Just the third party stores the private keys and use
them. All other parties just uses public keys.
Unfortunately, just a community of crypto-specialists can implement such a
mechanism.
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, radu.popescu@aldratech.com
Subject: Re: Database Encryption (now required by law in Italy)
In-Reply-To: <200403051927.11026.silvanadimartino@tin.it>
References: <OAEAKHEHCMLBLIDGAFELIEKOEOAA.matt@ymogen.net> <404864DD.6000207@aldratech.com> <200403051927.11026.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