Hi, Attached is a suggestion of adding a convenience view, allowing quickly looking up all objects owned by a given user.
Example:
SELECT * FROM ownerships WHERE rolname = 'joel' LIMIT 5;
regclass | obj_desc | rolname
------------------+-----------------------------------+---------
pg_class | table t | joel
pg_class | table foobar.foobar_policed_table | joel
pg_class | view ownerships | joel
pg_collation | collation foobar.foobar | joel
pg_event_trigger | event trigger foobar | joel
(5 rows)
This is similar to the suggested pg_permissions system view in other thread.
/Joel
0002-pg_ownerships.patch
Description: Binary data
