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 2567CD1D165 for ; Fri, 5 Mar 2004 20:40: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 66851-04 for ; Fri, 5 Mar 2004 16:40:08 -0400 (AST) Received: from vsmtp2.tin.it (vsmtp2alice.tin.it [212.216.176.142]) by svr1.postgresql.org (Postfix) with ESMTP id 9F381D1C4ED for ; Fri, 5 Mar 2004 16:40:04 -0400 (AST) Received: from host100-31.pool80116.interbusiness.it (80.116.31.100) by vsmtp2.tin.it (7.0.019) (authenticated as silvanadimartino) id 4043D1B5000CF65F; Fri, 5 Mar 2004 21:39:52 +0100 From: Silvana Di Martino To: "scott.marlowe" Subject: Re: Database Encryption (now required by law in Italy) Date: Fri, 5 Mar 2004 21:32:50 +0000 User-Agent: KMail/1.5 Cc: Alex Page , References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403052132.50642.silvanadimartino@tin.it> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/66 X-Sequence-Number: 12636 Alle 19:38, venerd=EC 5 marzo 2004, scott.marlowe ha scritto: > > Unfortunately, the new Italian law forces us to take seriously into > > account this catastrophic scenario and another one that is almost as > > worring: an unfaithful SysAdmin that copies your data and sells them to > > KGB. So, database encryption (and not disk encryption) is the _only_ > > answer. > > the only way for this to work is for it to be a "two key system" like the > military uses for missile launch. > > One sysadmin as the "key" to the database box, but the data is encrypted > before being sent to the database box on another system with another admin > with another "key". Preferably these two would never interact or know > each other. Well, this is not necessarly true. Data maintainers and SysAdmin performs= =20 different tasks (accordingly to italian law): - SysAdmins take care of the hardware and of the software. They should neve= r=20 need to access data. They just need to access the RDBMS software and its=20 configuration. - Just Data Maintainers need to access data. This should allow us to have two password for two different tasks. So, ther= e=20 is not any need to use the military scheme to enforce data security. See you ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it