pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
password accessibility
2+ messages / 2 participants
[nested] [flat]

* password accessibility
@ 2004-04-12 23:04 Greg Steffensen <greg.steffensen@richmond.edu>
  2004-04-13 06:07 ` Re: password accessibility Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Greg Steffensen @ 2004-04-12 23:04 UTC (permalink / raw)
  To: 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-----




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: password accessibility
  2004-04-12 23:04 password accessibility Greg Steffensen <greg.steffensen@richmond.edu>
@ 2004-04-13 06:07 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2004-04-13 06:07 UTC (permalink / raw)
  To: Greg Steffensen <greg.steffensen@richmond.edu>; pgsql-admin

Greg Steffensen wrote:
> 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.

That is not correct.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-04-13 06:07 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-12 23:04 password accessibility Greg Steffensen <greg.steffensen@richmond.edu>
2004-04-13 06:07 ` Peter Eisentraut <peter_e@gmx.net>

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