Re: Verifying a user. - Mailing list pgsql-general

From Steven Klassen
Subject Re: Verifying a user.
Date
Msg-id 20041014171924.GB20464@commandprompt.com
Whole thread Raw
In response to Re: Verifying a user.  (Steven Klassen <sklassen@commandprompt.com>)
List pgsql-general
* Steven Klassen <sklassen@commandprompt.com> [2004-10-14 10:07:39 -0700]:

> CREATE FUNCTION check_passwd(text,text) RETURNS boolean AS 'SELECT
> CASE WHEN passwd = md5($2) THEN true ELSE false END FROM pg_shadow
> WHERE usename = $1;' LANGUAGE sql;

Strike that - go with what Michael recommended. I glanced at the
password and didn't realize it was brewed with more than just the
password string.

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

pgsql-general by date:

Previous
From: Steven Klassen
Date:
Subject: Re: Verifying a user.
Next
From: Michael Fuhr
Date:
Subject: Re: Need some advice on appropriate PL strategy... ["solved/thanks"]