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

Re: MAY I HAVE YOUR ASSISTANCE

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: jameskitambara(at)yahoo(dot)co(dot)uk
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: MAY I HAVE YOUR ASSISTANCE
Date: 2008-09-01 07:28:36
Message-ID: dcc563d10809010028o323a8fc0r61bbfc8c86b91e7e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Mon, Sep 1, 2008 at 1:03 AM, James Kitambara
<jameskitambara(at)yahoo(dot)co(dot)uk> wrote:
>
> Please members of the PGSQL-SQL,
>
> I have one problem with the user table. I want to hide the password for the
> users.
>
> The table format is:
>
> user ( user_id, user_name, password)
>
> But I want the password to be encrypted so that when other users send the
> query:SELECT * FROM USER; The password must be gabbage.

Store it as an md5sum.  note that this is a one way function.  so
then, when someone logs in you md5 the password and compare it to the
md5 you saved in the db.

In response to

pgsql-sql by date

Next:From: D'Arcy J.M. CainDate: 2008-09-01 14:08:52
Subject: Re: MAY I HAVE YOUR ASSISTANCE
Previous:From: James KitambaraDate: 2008-09-01 07:03:51
Subject: MAY I HAVE YOUR ASSISTANCE

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