pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matt Davies <matt@mattdavies.net>
To: Mitch Pirtle <mitchy@spacemonkeylabs.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database Encryption (now required by law in Italy)
Date: Fri,  5 Mar 2004 08:10:05 -0700
Message-ID: <1078499405.4048984dcb2cd@www.mattdavies.net> (raw)
In-Reply-To: <40489607.1040204@spacemonkeylabs.com>
References: <200403050951.33230.silvanadimartino@tin.it>
	<40484403.70001@aldratech.com>
	<200403051245.10681.silvanadimartino@tin.it>
	<20040305121254.GK13042@nemesis.ox.icnet.uk>
	<40488640.1040409@spacemonkeylabs.com>
	<1078497790.404891feec25d@www.mattdavies.net>
	<40489607.1040204@spacemonkeylabs.com>

Quoting Mitch Pirtle <mitchy@spacemonkeylabs.com>:

> Matt Davies wrote:
> 
> > And how does one account for key information? If one encrypts any
> information
> > deemed worthy to be a key then you have to decrypt the entire database to
> find
> > particular information.  
> > 
> > 
> > Of course, you could keep keys unencrypted for use, but then again, why
> encrypt
> > it at all?
> 
> My question is much more basic than that:  Why encrypt anything beyond 
> passwords?  If you secure the accounts on the machine, and encrypt all 
> network traffic to the machine (ssh, scp, ssl) then what additional 
> security can you add?

I totally agree. Depending on interpretation this would totally negate the
usefullness of a database at all.

> 
> I have servers in remote facilities all over the world.  It is just not 
> possible for me to fly to each datacenter to be there at boot time when 
> I upgrade the kernel. I'd love the travel, but it is not feasible.
> 
> Second, hard-disk encryption will only come into play if someone stole 
> the hardware, right?  And even then, as long as the thing boots, then 
> they would have access!  That is, unless we went back to the 
> human-required-at-boot scenario.
> 
> As a former CSO for an 18000-person company, I'm a horribly paranoid 
> person when it comes to security; but security that is easily bypassed 
> (or dificult-to-impossible to enforce) is just added effort, isn't it?
> 
> Here is an idea to beat up on:  how about having the end user of the 
> application supply the key that is used to decrypt their data, and only 
> their data?  Take your basic, garden variety PHP website, for example.
> 
> When the user is given an account, they are also given a password.  This 
> password is also used as the key for the (blowfish, via mcrypt maybe?) 
> encryption of the data that gets stored for that person.  If you do not 
> have that key, then you cannot decrypt their data.  To boot, their key 
> is useless for everyone else's data as they used their own...
> 


I have thought about this scenario many times. The problem then is lost
passwords and so forth. All data is then useless because you can't decrypt it.


I worked for a public certification authority at one time and we were starting
to explore key escrow. That would be a useful feature, but in the end, one
sufficiently motivated will probably find a way to circumvent the system.



> Excellent discussion, maybe we could all come up with a sort of best 
> practices for PostgreSQL and security :)
> 
> -- Mitch
> 

Yes, excellent discussion. Security and privacy are always important, but it is
also necessary to remember the business case and use of databases and not
reduce their functionality to nil. It is a hard balance to find.





view thread (65+ messages)  latest in thread

Message-ID: <1078499405.4048984dcb2cd@www.mattdavies.net>
Permalink:  ../1078499405.4048984dcb2cd@www.mattdavies.net/
Also on:    postgresql.org/message-id/1078499405.4048984dcb2cd@www.mattdavies.net

 · 

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: matt@mattdavies.net, mitchy@spacemonkeylabs.com
  Subject: Re: Database Encryption (now required by law in Italy)
  In-Reply-To: <1078499405.4048984dcb2cd@www.mattdavies.net>
  References: <200403050951.33230.silvanadimartino@tin.it> <40484403.70001@aldratech.com> <200403051245.10681.silvanadimartino@tin.it> <20040305121254.GK13042@nemesis.ox.icnet.uk> <40488640.1040409@spacemonkeylabs.com> <1078497790.404891feec25d@www.mattdavies.net> <40489607.1040204@spacemonkeylabs.com> <1078499405.4048984dcb2cd@www.mattdavies.net>

* 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