query of database to get permitted users list

From: pw <p(dot)willis(at)telus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: query of database to get permitted users list
Date: 2004-05-11 03:35:43
Message-ID: 40A04A0F.3000306@telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a query of pg_database to find the owners of each available database.
How can I query to get the users that have permissions on any particular
database?
pg_user always contains *all* database users regardless of whether they have
granted permissions to the current db.

Thanks for any ideas.

Peter

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2004-05-11 06:59:42 Re: Adding MERGE to the TODO list (resend with subject)
Previous Message Tom Lane 2004-05-10 23:49:42 Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT