Re: [ADMIN] Secure DB Systems - How to

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Daniel Struck <struck(dot)d(at)retrovirology(dot)lu>
Cc: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>, pgsql-php(at)postgresql(dot)org
Subject: Re: [ADMIN] Secure DB Systems - How to
Date: 2004-07-27 19:49:05
Message-ID: 20040727194905.GA20499@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-hackers-win32 pgsql-php pgsql-sql

On Tue, Jul 27, 2004 at 13:41:33 +0200,
Daniel Struck <struck(dot)d(at)retrovirology(dot)lu> wrote:
> > Exactly. That is the only way to ensure that the data is never
> > decrypted within the database or database server.
>
> But then one will also lose the ability to make sql-queries with the encrypted columns . Something I wouldn't want to miss, or else it doesn't make sense to store this data in a database if one can't work with it.

That depends on the kind of queries. Searching for exact matches should
work fine. Some other things can be done in special cases.

If you are interested in this topic you may want to pick up a copy of
Translucent Databases.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Hiroshi Saito 2004-07-28 00:30:06 Re: pgadmin3 on freebsd
Previous Message Douglas, Aaron 2004-07-27 19:39:09 Error Message: Multiple-step OLE DB operation generated errors. C heck each OLE DB status value, if available. No work was done.

Browse pgsql-admin by date

  From Date Subject
Next Message Christian Hache 2004-07-28 11:48:31 Como usar MDB Tools
Previous Message alvaro 2004-07-27 15:58:41 SOS ---- Could you help me with pg_resetxlog

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2004-07-27 21:00:50 Re: win32 pgsql not installable
Previous Message Sean S. O'Donovan 2004-07-27 14:22:16 Re: Postres Beta Installer Error on W2K SP4

Browse pgsql-php by date

  From Date Subject
Next Message Lynna Landstreet 2004-07-28 19:21:44 Strange warning message
Previous Message Daniel Struck 2004-07-27 11:41:33 Re: [ADMIN] Secure DB Systems - How to

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2004-07-27 23:11:03 Re: surrogate key or not?
Previous Message Daniel Struck 2004-07-27 11:41:33 Re: [ADMIN] Secure DB Systems - How to