Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f43NYPA50484 for ; Thu, 3 May 2001 19:34:35 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f43NYE1q028902; Thu, 3 May 2001 17:34:14 -0600 Date: Thu, 3 May 2001 17:34:14 -0600 From: Roberto Mello To: Subhramanya Shiva Cc: pgsql-sql@postgresql.org Subject: Re: How to encode and decode password in pgsql !! Message-ID: <20010503173414.A28881@cc.usu.edu> References: <1070.192.168.0.5.988745877.squirrel@mail.archeanit.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: <1070.192.168.0.5.988745877.squirrel@mail.archeanit.net>; from shiva@archeanit.com on Wed, May 02, 2001 at 01:07:57AM +0530 X-Archive-Number: 200105/18 X-Sequence-Number: 2816 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!