From: Rod Taylor <rbt@rbt.ca>
To: Valerie Goodman <val@webtribe.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: "hide" values in a column
Date: 12 Mar 2003 16:43:09 -0500
Message-ID: <1047505388.55840.53.camel@jester> (raw)
In-Reply-To: <NFBBILEJLCBGFCLICKKMIEOJCJAA.val@webtribe.net>
References: <NFBBILEJLCBGFCLICKKMIEOJCJAA.val@webtribe.net>
On Wed, 2003-03-12 at 16:12, Valerie Goodman wrote:
> Background: The maniacs I work for want an e-suggestion box. The identity
> of the suggestor must not be known, but the suggestion box administrator
> must be able to respond privately back to that person so I can't just
> completely leave out the identity of a suggestor against his/her suggestion.
> The suggestor is meant to be have complete anonymity.
>
> The real question: How do I completely "hide"/encrypt the values in the
> emp_id column even from me (who would be using psql) without the easy
> possibility of decoding it?
Write something in C, load it as a function.
Then call it when inserting data into that field.
I suggest using GPG and encrypting via a public key. This ensures only
the person with the private key can decrypt the information.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, val@webtribe.net
Subject: Re: "hide" values in a column
In-Reply-To: <1047505388.55840.53.camel@jester>
* 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