From: Silvana Di Martino <silvanadimartino@tin.it>
To: Peter Galbavy <peter.galbavy@knowtion.net>
To: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Mon, 8 Mar 2004 12:26:10 +0000
Message-ID: <200403081226.10550.silvanadimartino@tin.it> (raw)
In-Reply-To: <00b701c404f0$562f2950$152ca8c0@petersdesktopho>
References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is>
<200403051251.54463.silvanadimartino@tin.it>
<00b701c404f0$562f2950$152ca8c0@petersdesktopho>
Alle 09:32, lunedì 8 marzo 2004, Peter Galbavy ha scritto:
> Perhaps, given the potential commercial necessities of this for larger
> organisations, find out what Oracle and IBM propose doing or have
> implemented ?
I do not know of IBM.
Oracle has a system similar to pgcrypto but more sophisticated. I do not know
if it can use encrypted indexes, encrypted dates and encrypted times (it is
likely but I did not tried, yet). It stores its "global encryption password"
into a system table in encrypted form. Only authenticated users can decrypt
data.
Something like that can be done with PostgreSQL, as well. The problem is that
I have to store somewhere a password in clear text (either the password used
to encrypt/decrypt data or the password used to decrypt this password).
Oracle has a built-in feature for encrypting/decrypting this password's
password.
> For strict comformance, you really should consult a local legal
> professional for their opinion, and be prepared to pay for that protection.
We are doing it. Unfortunately, our lawyer still have to discuss technical
problems with a technician (that is: me).
BTW: It looks like I'm the only one here facing this problem. That's
surprising, given the number of countries that have a law like the italian
one and the wide diffusion of PostgreSQL.
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, peter.galbavy@knowtion.net
Subject: Re: Database Encryption (now required by law in Italy)
In-Reply-To: <200403081226.10550.silvanadimartino@tin.it>
References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403051251.54463.silvanadimartino@tin.it> <00b701c404f0$562f2950$152ca8c0@petersdesktopho> <200403081226.10550.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