query of database to get permitted users list

Started by pwalmost 22 years ago1 messagesgeneral
Jump to latest
#1pw
p.willis@telus.net

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