Re: How to encode and decode password in pgsql !!

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Subhramanya Shiva <shiva(at)archeanit(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to encode and decode password in pgsql !!
Date: 2001-05-03 23:34:14
Message-ID: 20010503173414.A28881@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, May 02, 2001 at 01:07:57AM +0530, Subhramanya Shiva wrote:
> hi all
>
> how to store password details in a table. in encoded form
> and how to decode it.
>
> in mysql ...we r having encoding and decoding for a password
> security ... so how to do in pgsql...

I usually do the encrypting in the client application (AOLserver, PHP),
store the encrypted password, when the user comes back and enters the
password I encrypt it and test it against what's on the database.

-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Thou shall not kill, unless it's for dinner!

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2001-05-04 11:35:15 Re: How to encode and decode password in pgsql !!
Previous Message Joel Burton 2001-05-03 20:44:17 RE: "correct" sorting.