Re: How to store a password encripted in a user defined table

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Eugenio Flores" <eflores767003(at)yahoo(dot)com(dot)mx>, PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to store a password encripted in a user defined table
Date: 2007-03-01 08:21:06
Message-ID: b35603930703010021y19b9807awbd2499bce9df952e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 3/1/07, Eugenio Flores <eflores767003(at)yahoo(dot)com(dot)mx> wrote:
> Hello, I wonder if somebody knows how to store passwords in a
> column that is part of a user defined table.
Assuming that your passwords are application specific use
a sha1 or md5 algorithm (depending on how sensitive your data is)
and store that in a varchar or char field. When the user authenticates
the password gets hashed in the app and compared against the
stored hash.

Cheers,
Andrej

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Eugenio Flores 2007-03-01 11:06:22 Re: How to store a password encripted in a user defined table
Previous Message Sabin Coanda 2007-03-01 07:56:25 column definition list of a dynamic record argument