Encoding passwords - Mailing list pgsql-general

From Mike Arace
Subject Encoding passwords
Date
Msg-id F76Odutox7nyeKzGZuN0000742c@hotmail.com
Whole thread Raw
Responses Re: Encoding passwords
Re: Encoding passwords
Re: Encoding passwords
Re: Encoding passwords
List pgsql-general
Hey everyone,

Is there a function out there for pg which allows you to generate a random
number given a seed value?  I'm trying to create a users table which would
require the storage of a password in a database field, and I'm hesitant to
put it in there in plain text, despite the fact I plan to put very tight
restrictions on that particular table.  Ideally, I would encode each letter
one by one, using the random number generator with the previous letter as a
seed for the next.  I was told that certain unixes use a similar way to
store their passwords, and it seemed to make sense for this application.  I
noticed that there is a rand() function, but I'm a little slow today and
couldn't think a way to use that in this scenario.  Any suggestions would be
greatly appreciated.

Thanks
Mike

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


pgsql-general by date:

Previous
From: Frank Joerdens
Date:
Subject: virtual filesystem atop a PostgreSQL database
Next
From: Jan Pruner
Date:
Subject: Fwd: Re: virtual filesystem atop a PostgreSQL database