Skip site navigation (1) Skip section navigation (2)

Re: Storing/Using Passwords

From: Prasanth <dbadmin(at)nqadmin(dot)com>
To: William Shatner <shatner(dot)william(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Storing/Using Passwords
Date: 2005-05-18 14:33:16
Message-ID: 428B522C.1050301@nqadmin.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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(at)postgresql(dot)org)
> 
> 

In response to

pgsql-jdbc by date

Next:From: Jarosław Jan PysznyDate: 2005-05-22 01:14:27
Subject: Translation update: pl_PL
Previous:From: Scott MarloweDate: 2005-05-18 14:32:33
Subject: Re: [JDBC] Storing/Using Passwords

pgsql-general by date

Next:From: HugoDate: 2005-05-18 15:23:58
Subject: Newbie question
Previous:From: Scott MarloweDate: 2005-05-18 14:32:33
Subject: Re: [JDBC] Storing/Using Passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group