Verifying a user.

From: Thomas Hallgren <thhal(at)mailblocks(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Verifying a user.
Date: 2004-10-14 15:27:20
Message-ID: ckm5so$smr$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm connected to a database and I want to verify that a username and
password for some user is correct. I know I can verify a users existence
by doing:

select exists(select * from pg_user where usename = $1)

but I would like to verify the correctness of the password as well. Is
there a way to do that using SQL?

Regards,

Thomas Hallgren

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robin Ericsson 2004-10-14 15:30:58 not using index through procedure
Previous Message Michael Fuhr 2004-10-14 15:25:54 Re: Date format for bulk copy