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 1C6A1D1D85E for ; Fri, 5 Mar 2004 19:28:28 +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 41652-04 for ; Fri, 5 Mar 2004 15:28:27 -0400 (AST) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by svr1.postgresql.org (Postfix) with ESMTP id 29589D1CA67 for ; Fri, 5 Mar 2004 15:28:26 -0400 (AST) Received: from host91-33.pool8248.interbusiness.it (82.48.33.91) by vsmtp3.tin.it (7.0.019) (authenticated as silvanadimartino) id 402CD18F0041E6FE; Fri, 5 Mar 2004 20:28:25 +0100 From: Silvana Di Martino To: Mitch Pirtle , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Date: Fri, 5 Mar 2004 19:45:33 +0000 User-Agent: KMail/1.5 References: <200403050951.33230.silvanadimartino@tin.it> <20040305121254.GK13042@nemesis.ox.icnet.uk> <40488640.1040409@spacemonkeylabs.com> In-Reply-To: <40488640.1040409@spacemonkeylabs.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403051945.33848.silvanadimartino@tin.it> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/58 X-Sequence-Number: 12628 Alle 13:53, venerd=EC 5 marzo 2004, Mitch Pirtle ha scritto: > The same logic applies to encrypting the data in the database - > somewhere on your server the application has to know how to decrypt it, > and that means anyone that gains access to your server will have that > ability also... That's true, of course but... 1) The cryptographic keys used by the application to access the data could = be=20 stored (encrypted) inside a compiled C/C++ or Delphi/Kylyx program. 2) No matter what we think about data encryption, a (stupid) italian law=20 enforces it ("Allegato B, Decreto Legge 196/03, Dicembre 2003). 3) As I told in another message, our law prohibites that our SysAdmin had= =20=20 access to data. Just authorized operators can read them. > I understand (and demand) requiring SSL connections for database > clients, and MD5 hashing of passwords before storing in the database, > but implementing two-way encryption of database data just doesn't make > sense to me. Neither to me, actually, but it makes to our law-makers (Have you heard of= =20=20 Silvio Berlusconi?). See you ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it