From: Greg Steffensen <greg.steffensen@richmond.edu>
To: pgsql-admin@postgresql.org
Subject: password accessibility
Date: Mon, 12 Apr 2004 19:04:29 -0400
Message-ID: <407B207D.7010900@richmond.edu> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: greg.steffensen@richmond.edu
Subject: Re: password accessibility
In-Reply-To: <407B207D.7010900@richmond.edu>
References: <407B207D.7010900@richmond.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox