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.
pgadmin-support by date
|Next:||From: Bartosz Dmytrak||Date: 2012-02-28 09:10:34|
|Subject: pgAdmin hangs|
|Previous:||From: Guillaume Lelarge||Date: 2012-02-27 21:28:18|
|Subject: Re: Failed to write to history file|