On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > 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. >
IOW, you want the opposite of the "Role membership" tab. Not sure if it really makes sense in pgAdmin. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
