pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (65+ messages)  latest in thread

Message-ID: <200403081226.10550.silvanadimartino@tin.it>
Permalink:  ../200403081226.10550.silvanadimartino@tin.it/
Also on:    postgresql.org/message-id/200403081226.10550.silvanadimartino@tin.it

 · 

reply

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