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). 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, ... ). Is there any solution out there ? Thanks in advance tom ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org