[EMAIL PROTECTED] 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?).
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
