Manually authenticating users in pg_shadow

From: "William Harazim" <wharazim(at)fulcoinc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Manually authenticating users in pg_shadow
Date: 2004-01-28 00:06:09
Message-ID: A1CC9E8EDC33E74C84357A70D46C35C148CA00@barracuda.denville.fulcoinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way, having a user entered username and password, to select a single row from pg_shadow which is using md5 password encryption?

I'm currently authenticating web users (.asp page) with our own user table that uses crypt() to store passwords. I'd like to remove our 'redundant' user table and use pg_shadow. The authentication function I'm using is included in the attachment...

Thanks.

<<auth_user.txt>>
William Harazim, Software Engineer, Fulco Inc. 973-627-2427, x129

Attachment Content-Type Size
auth_user.txt text/plain 384 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerome Lyles 2004-01-28 00:13:04 Re: Permission Problems:-)?
Previous Message Alex Satrapa 2004-01-27 23:26:49 Re: Is autocommit=true bad?