Manually authenticating users in pg_shadow - Mailing list pgsql-general

From William Harazim
Subject Manually authenticating users in pg_shadow
Date
Msg-id A1CC9E8EDC33E74C84357A70D46C35C148CA00@barracuda.denville.fulcoinc.com
Whole thread Raw
Responses Re: Manually authenticating users in pg_shadow  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
passwordencryption? 

I'm currently authenticating web users (.asp page) with our own user table that uses crypt()  to store passwords. I'd
liketo 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

pgsql-general by date:

Previous
From: Alex Satrapa
Date:
Subject: Re: Is autocommit=true bad?
Next
From: Jerome Lyles
Date:
Subject: Re: Permission Problems:-)?