password accessibility

From: Greg Steffensen <greg(dot)steffensen(at)richmond(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: password accessibility
Date: 2004-04-12 23:04:29
Message-ID: 407B207D.7010900@richmond.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm in the process of integrating a jabber server into a
postgresql-based web portal. The portal has a separate postgresql
user for every registered user of the site. Authentication on the
site is easy enough; the site just attempts to connect to the db using
the provided credentials, and if its successful, the user is logged
in. The jabber server needs the passwords (or their md5 hashes)
visible in standard table format for authentication, though. I'd like
to construct a view containing the usernames, passwords, etc in
jabber's required format, but system catalog information doesn't seem
to be accessible to views. Is there any way to pull the information
from the pg_shadow catalog into a view?

Greg Steffensen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAeyB9Gt2K2bwjlc0RAj7QAJ9SfEYykhH5YvMqGZJopXouaSFz5QCfZWD7
XvSmm9Tik6Jt/Di762T72So=
=XD4x
-----END PGP SIGNATURE-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-13 06:07:05 Re: password accessibility
Previous Message Tom Lane 2004-04-12 22:36:09 Re: Location of a new column