Re: [JDBC] Storing/Using Passwords

On Wed, 2005-05-18 at 05:36, William Shatner wrote:
> Hello,
>
>
> I am using PostgreSQL 8.0 as a data repository for a Java based system
> and I now want to add users to my java program with usernames and
> passwords. Is their an encrypted password field I can use in a User
> Table to store passwords or what would be the best way to approach
> this?
>
> The usernames and passwords will apply for connection to the  to the
> java program only. All users will be connecting to the PostgreSQL
> database transparently using the same username/password stored in a
> properties file to validate their java program username/passwords.

The md5() function is quite useful for this.  It's a one way hash
function that's commonly used by many applications to create password
hashes.