Re: Groups and Users

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Brad Rhine <rhino(at)etown(dot)k12(dot)pa(dot)us>
Cc: PGSQL Novices <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Groups and Users
Date: 2003-07-08 04:37:13
Message-ID: Pine.LNX.4.44.0307081003480.1198-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Given a username, how do I find out which groups that user is a member
> of? I'm sure I'm missing something obvious.

IMO, there is no straight method, but you can get it using a plpgsql
function. But the list of users belonging to a group can be found in
pg_group table. The userids are stored in an array.

regards,
bhuvaneswaran

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Herbie McDuck 2003-07-08 05:57:45 OK..time for STUPID to say somthing
Previous Message Matthew Nuzum 2003-07-08 00:47:00 Re: Extreme high load averages