Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

query of database to get permitted users list

0 views
Skip to first unread message

pw

unread,
May 10, 2004, 11:35:43 PM5/10/04
to
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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

0 new messages