encrypting a password field in the database
| От | Fran Fabrizio |
|---|---|
| Тема | encrypting a password field in the database |
| Дата | |
| Msg-id | 3B698430.47B9471B@mmrd.com обсуждение исходный текст |
| Список | pgsql-general |
Hello, One of my fields is used to store a password field. I would like this field to be encrypted. The way we do it now is to have our perl scripts encrypt it before inserting it and decrypt it after selecting it. This is something of a pain because there are 4 different machines that have need of this functionality, so that means I have to maintain 4 installs of the helper module that contains the encryption/decryption code. It makes more sense to me to localize this in the database itself, and provide a pair of functions to encrypt and decrypt a string which we would use when inserting/selecting the password. However, I looked into plperl and realized (the hard way) that plperl restricts you from doing anything useful like use Crypt::Blowfish; for security reasons. Is there another way I could localize this code (or something that performs the same function) in the database or at least on the server that runs the database? Thanks, Fran
В списке pgsql-general по дате отправления: