Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-adminpgsql-hackers-win32pgsql-phppgsql-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

pgsql-php by date

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

pgsql-admin by date

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

pgadmin-support by date

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

pgsql-hackers-win32 by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group