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 846F3D1B9AF for ; Mon, 8 Mar 2004 12:30:57 +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 74819-06 for ; Mon, 8 Mar 2004 08:30:56 -0400 (AST) Received: from mailstore-1.mail.knowledge.com (frida.london.knowtion.net [213.170.2.69]) by svr1.postgresql.org (Postfix) with ESMTP id BE82AD1B979 for ; Mon, 8 Mar 2004 08:30:52 -0400 (AST) Received: from [213.253.17.15] (helo=petersdesktopho) by mailstore-1.mail.knowledge.com with asmtp (Exim 3.36 #1) id 1B0JuI-0000zv-00; Mon, 08 Mar 2004 12:30:54 +0000 Message-ID: <006f01c40509$3807b410$152ca8c0@petersdesktopho> From: "Peter Galbavy" To: "Silvana Di Martino" , References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403051251.54463.silvanadimartino@tin.it> <00b701c404f0$562f2950$152ca8c0@petersdesktopho> <200403081226.10550.silvanadimartino@tin.it> Subject: Re: Database Encryption (now required by law in Italy) Date: Mon, 8 Mar 2004 12:30:58 -0000 Organization: Knowtion Ltd. MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/122 X-Sequence-Number: 12691 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. > 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. I cannot speak or read Italian, so any reference to an English version of the legislation or analysis of it would be greatly appreciated. As some background to my next comments, for those not in the EU, there is a lot of inconsitency in the way that member countries implement EU directives. These glaring differences sometimes, no scratch that: ALWAYS, cost taxpayers dear, while the legislators and the civil and criminal justice systems sorting issues out after the fact, and at great cost. Two observations in this light; 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 many sole traders that I know of). 2. I have been unable to find, as an amateur with interests in the subject, 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 time 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 ? rgds, -- Peter