By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Storing passwords

P: n/a

My application needs to store user names and passwords in the database
via JDBC connection. What is the right way to do this? What should be
the database type of the password column? How do I encrypt the password
before sending it to the database? What other database settings need to
be enabled for this to work?

Thanks.

Oleg

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.