From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: feature request - show role members |
Date: | 2012-02-28 15:20:46 |
Message-ID: | 1330442446.2246.54.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-02-28 15:28:34 | Re: Panel height redimensioning in Query builder |
Previous Message | Guillaume Lelarge | 2012-02-28 13:40:44 | Re: pgAdmin hangs |