Skip site navigation (1) Skip section navigation (2)

feature request - show role members

From: Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>
To: pgadmin-support(at)postgresql(dot)org
Subject: feature request - show role members
Date: 2012-02-28 08:22:05
Message-ID: CAD8_UcZABFncQdKcUY1ACnvuH-PphDJJHGLdkODh3LFO-VxGBw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

Responses

pgadmin-support by date

Next:From: Bartosz DmytrakDate: 2012-02-28 09:10:34
Subject: pgAdmin hangs
Previous:From: Guillaume LelargeDate: 2012-02-27 21:28:18
Subject: Re: Failed to write to history file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group