Two-way encryption - Mailing list pgsql-general

From Patrick Simcoe
Subject Two-way encryption
Date
Msg-id CAMJ77RnTxXfMO3JPw7WTfLXtdvi=nLy+V9r_n0rTi8CAPtzTOA@mail.gmail.com
Whole thread Raw
Responses Re: Two-way encryption
Re: Two-way encryption
List pgsql-general
I have a question regarding two-way encryption data for specific columns.

Does anyone have a technique or recommendation for two-way encryption which somehow obfuscates the decrypt key so that it isn't easily retrievable from the database or the application source code? We've already considered (a) letting users hold the decrypt key and (b) obfuscating the decrypt key with the user's own (one-way encrypted) password, but neither of these approaches are viable for us.

pgsql-general by date:

Previous
From: Patrick Simcoe
Date:
Subject:
Next
From: Kynn Jones
Date:
Subject: Re: how to create a role with no privileges?