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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
