> 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