X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 209B0D1B8BC for ; Mon, 8 Mar 2004 11:28:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67987-01 for ; Mon, 8 Mar 2004 07:28:08 -0400 (AST) Received: from vsmtp1.tin.it (vsmtp1alice.tin.it [212.216.176.141]) by svr1.postgresql.org (Postfix) with ESMTP id 13C2AD1D1F2 for ; Mon, 8 Mar 2004 07:28:06 -0400 (AST) Received: from host92-31.pool80116.interbusiness.it (80.116.31.92) by vsmtp1.tin.it (7.0.019) (authenticated as silvanadimartino) id 4034BCBF00358020; Mon, 8 Mar 2004 12:27:54 +0100 From: Silvana Di Martino To: "Peter Galbavy" , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Date: Mon, 8 Mar 2004 12:26:10 +0000 User-Agent: KMail/1.5 References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403051251.54463.silvanadimartino@tin.it> <00b701c404f0$562f2950$152ca8c0@petersdesktopho> In-Reply-To: <00b701c404f0$562f2950$152ca8c0@petersdesktopho> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403081226.10550.silvanadimartino@tin.it> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/121 X-Sequence-Number: 12690 Alle 09:32, luned=EC 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 kn= ow=20 if it can use encrypted indexes, encrypted dates and encrypted times (it is= =20 likely but I did not tried, yet). It stores its "global encryption password= "=20 into a system table in encrypted form. Only authenticated users can decrypt= =20 data.=20 Something like that can be done with PostgreSQL, as well. The problem is th= at=20 I have to store somewhere a password in clear text (either the password use= d=20 to encrypt/decrypt data or the password used to decrypt this password).=20 Oracle has a built-in feature for encrypting/decrypting this password's=20 password. > For strict comformance, you really should consult a local legal > professional for their opinion, and be prepared to pay for that protectio= n. We are doing it. Unfortunately, our lawyer still have to discuss technical= =20 problems with a technician (that is: me). BTW: It looks like I'm the only one here facing this problem. That's=20 surprising, given the number of countries that have a law like the italian= =20 one and the wide diffusion of PostgreSQL. See you. ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it