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 7DCD1D1D2CC for ; Mon, 8 Mar 2004 21:14:33 +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 20710-01 for ; Mon, 8 Mar 2004 17:14:33 -0400 (AST) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by svr1.postgresql.org (Postfix) with ESMTP id 14BF5D1D1F2 for ; Mon, 8 Mar 2004 17:14:31 -0400 (AST) Received: from host173-9.pool80182.interbusiness.it (80.182.9.173) by vsmtp3.tin.it (7.0.019) (authenticated as silvanadimartino) id 402CD18F00497C26; Mon, 8 Mar 2004 22:14:18 +0100 From: Silvana Di Martino To: "Peter Galbavy" , Subject: Re: Database Encryption (now required by law in Italy) Date: Mon, 8 Mar 2004 20:16:20 +0000 User-Agent: KMail/1.5 References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403081226.10550.silvanadimartino@tin.it> <006f01c40509$3807b410$152ca8c0@petersdesktopho> In-Reply-To: <006f01c40509$3807b410$152ca8c0@petersdesktopho> MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200403081831.19978.silvanadimartino@tin.it> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/133 X-Sequence-Number: 12702 Alle 12:30, luned=EC 8 marzo 2004, Peter Galbavy ha scritto: > Silvana Di Martino wrote: > > 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. > > This can then be broken. Anything that does without some sort of human > intervention is waiting to be hacked one way or another. You are right, of course. For having a reasonably robust system, (at least)= we=20 should keep the "password's password" on a separated (and well-protected)= =20 server and access via SSH or SSL when needed. > I cannot speak or read Italian, so any reference to an English version of > the legislation or analysis of it would be greatly appreciated. Being italian law, addressed to italian speakers, no english translation is= =20 available. I cannot translate it because of lack of time. Sorry... > 1. Some countries within the EU still have national laws, unless I blinked > and they disappeared, that mandate some control over cryptography. > Historically, France was certainly one - anyone with current specifics ? > This leads to a potential conflict if the EU mandates in anyway that > countries must require _encryption_ (as opposed to string protection) of > personal data by data controllers (i.e. ever incorporated business and ma= ny > sole traders that I know of). Our governement is discussing since a long time this topic and seems to be= =20 possible that cryptography will be prohibited. How do they hope to reconcil= e=20 this prohibition with the requirement to use cryptography to protect person= al=20 data is behind my ability to understand the human logic. > 2. I have been unable to find, as an amateur with interests in the subjec= t, > a *single* instance of a prosecution under Data Protection laws in the UK. > Lots of "enforcement by discussion and threat" and stuff, but no court ti= me > to test the laws directly. Probably don't know the right places to look. > Again, anyone with real data for the UK and the EU in general for how > existing Data Protection laws have been enforced ? I can tell you for sure that we never had any actual prosecutions in Italy,= =20=20 neither under the "old" law (675/96) nor under the "new" one (196/03). This= =20 does not mean that we will not see any prosecution in the future, as well. = A=20 company that violates the new law can receive a 35.000 euro fine and this= =20 money can be a strong motivation for our governement. See you ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it