Re: [GENERAL] Encryption For Specific Column- Where to store the key

2011-06-16 Thread Manuel Gysin
ent of the posted link is not from me) What I could do for the fields which needs protection is the store the first or last letter as plain text, so the user knows what it is but an attacker who gains access not. While I need to control the data for billing or validity I can load the key from a usb stick or so like you mentioned above and else there is no access to the data. This sounds very good! (While the user knows what data he provided, he has no problems to read "Main** 34" as his address, but an attacker can't do much with this data.) Thanks a lot! Kind Regards Manuel Gysin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Encryption For Specific Column- Where to store the key

2011-06-15 Thread Manuel Gysin
crypt the columns? A discussion about this topic can be found under http://www.experts-exchange.com/Database/PostgreSQL/Q_21934798.html (answers are not all the time displayed...) But there were no final solution at all. Kind regards Manuel Gysin -- Sent via pgsql-general mailing list (pgsql-general@post