Re: Storing/Using Passwords - Mailing list pgsql-jdbc

From Prasanth
Subject Re: Storing/Using Passwords
Date
Msg-id 428B522C.1050301@nqadmin.com
Whole thread Raw
In response to Storing/Using Passwords  (William Shatner <shatner.william@gmail.com>)
List pgsql-jdbc
You can probably store a md5 of the password.

But when you do that you can't retrieve the password.

If some one forgets their password you have to reset it.

-Prasanth.


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.
>
>
> Kind Regards,
> Will
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Questions on property values
Next
From: Scott Marlowe
Date:
Subject: Re: Storing/Using Passwords