Hi, I would like to see who is member of selected role, somewhere in group role form. Hope this will help to administrate multiuser environments.
This feature is covered by query: SELECT p.rolname, m.rolname as member, g.rolname as grantor FROM pg_authid p INNER JOIN pg_auth_members am ON (p.oid = am.roleid) INNER JOIN pg_authid m ON (am.member = m.oid) INNER JOIN pg_authid g ON (am.grantor = g.oid) WHERE p.rolname = 'MyRole' This query shows of course only direct members, feature could be extended to indirect members too (and mark them as indirect). Right now I use workaround with macro. Thanks in advance. Regards, Bartek
