| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Storing passwords |
| Date: | 2003-12-01 20:32:08 |
| Message-ID: | Pine.LNX.4.44.0312012130570.23890-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Oleg Lebedev writes:
> My application needs to store user names and passwords in the database
> via JDBC connection. What is the right way to do this?
One table, one column for the name, one column for the password.
> What should be the database type of the password column?
text or bytea, depending on how you encrypt it.
> How do I encrypt the password before sending it to the database?
Check out contrib/pgcrypto.
> What other database settings need to be enabled for this to work?
None.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randal L. Schwartz | 2003-12-01 20:42:39 | Re: Good open source mailing list system PHP / Postgresql |
| Previous Message | Peter Eisentraut | 2003-12-01 20:30:32 | Re: I need your help. I'm confused with the files ... |