pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Galbavy <peter.galbavy@knowtion.net>
To: Silvana Di Martino <silvanadimartino@tin.it>
To: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Mon, 8 Mar 2004 12:30:58 -0000
Message-ID: <006f01c40509$3807b410$152ca8c0@petersdesktopho> (raw)
References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is>
	<200403051251.54463.silvanadimartino@tin.it>
	<00b701c404f0$562f2950$152ca8c0@petersdesktopho>
	<200403081226.10550.silvanadimartino@tin.it>

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




view thread (65+ messages)  latest in thread

Message-ID: <006f01c40509$3807b410$152ca8c0@petersdesktopho>
Permalink:  ../006f01c40509$3807b410$152ca8c0@petersdesktopho/
Also on:    postgresql.org/message-id/006f01c40509$3807b410$152ca8c0@petersdesktopho

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: peter.galbavy@knowtion.net, silvanadimartino@tin.it
  Subject: Re: Database Encryption (now required by law in Italy)
  In-Reply-To: <006f01c40509$3807b410$152ca8c0@petersdesktopho>
  References: <0A5B2E3C3A64CA4AB14F76DBCA76DDA44E2DA6@seifur.hnit.is> <200403051251.54463.silvanadimartino@tin.it> <00b701c404f0$562f2950$152ca8c0@petersdesktopho> <200403081226.10550.silvanadimartino@tin.it> <006f01c40509$3807b410$152ca8c0@petersdesktopho>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox