Re: About groups in postgres

> 1) Is there any way of asking postgres the groups a user account
>    belongs to?

You can figure this out, but I don't know of a nice clean way of doing
it.  Check out the pg_group table.  There's got to be a 'value in
array' type function that could make that an easy select.

> 2) Let's suppose I have a user account that belongs to several
> groups, how can I tell postgres that I want access the database but
> just with the priviledges of one of the groups?

You don't want the intersection of permissions?  I'd create a new user
account: I don't know that there's a way to rescind privs that have
been granted to you.  -sc

--
Sean Chittenden