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

Re: group role membership

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom(dot)Zschockelt(at)flender(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: group role membership
Date: 2005-11-10 13:51:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Tom(dot)Zschockelt(at)flender(dot)com wrote:
> Hi,
> with postgres 8.1 and pgadmin 1.4.0 I found no way ( except a select on 
> pg_catalog-tables ) to
> get a list of all members belonging to certain group role.
> The other way around works ( all assigned roles to a certain role).

This isn't implemented yet; it will require an additional tab "members".

> If we use group roles to manage access to objects it would be neccessary 
> to get a list of all
> login-roles that are able to do e.g. a select .
> It would be nice if an solution will step through all recursive level ( 
> e.g. if a login-role is member of a group-role which is member of a 
> group-role itself, ... ).

Please make a proposal how this should look like concretely, and how it 
should be controlled (context menu on object, property or so?).


In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2005-11-10 13:55:25
Subject: Re: Creating table - adding columns
Previous:From: Andreas PflugDate: 2005-11-10 13:37:21
Subject: Re: Tabs in query editing window

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