Re: Why an array in pg_group?

Tom Lane wrote:
> > I have trouble implementing a way to easily check whether a user is part
> > of a group.
>
> Perhaps you could create a table that has no purpose except to be a
> permissions-check target, and set it up to have permissions granted only
> to the group you care about. Then use has_table_privilege().
>
> In the long run I'd have no objection to adding an is_group_member()
> function (need a better choice of name, perhaps) to cater to this sort
> of request. Too late for 7.3 though.

I believe Joe Conway already coded that, but it didn't make it into 7.3.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073