X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 53CFDD1B48D for ; Mon, 12 Jan 2004 21:21:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 59349-10 for ; Mon, 12 Jan 2004 17:21:01 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id ECB15D1D8BF for ; Mon, 12 Jan 2004 17:20:58 -0400 (AST) Received: (qmail 11725 invoked by uid 500); 12 Jan 2004 21:21:38 -0000 Date: Mon, 12 Jan 2004 15:21:38 -0600 From: Bruno Wolff III To: ListSrv Cc: pgsql-admin@postgresql.org Subject: Re: Tablerights for User in Group Message-ID: <20040112212138.GA23970@wolff.to> Mail-Followup-To: ListSrv , pgsql-admin@postgresql.org References: <8utLb.27735$Tz1.15693@news.chello.at> <40030C39.5030806@wilsoft.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40030C39.5030806@wilsoft.nl> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/93 X-Sequence-Number: 11956 On Mon, Jan 12, 2004 at 22:06:01 +0100, ListSrv wrote: > Hi, > > Is it possible to query de backend database for retrieving rights of an > user in a group for a > table? In 7.4 there is a group of functions that seem to do what you want. The functions are listed in table 9-37 which is in the section for miscellaneous functions. I think these functions are a relatively recent addition, and that you may need to be running 7.4 to use them.