> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
