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 605CDD1D168 for ; Mon, 12 Jan 2004 22:54:04 +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 86579-09 for ; Mon, 12 Jan 2004 18:53:35 -0400 (AST) Received: from linux.wilsoft.nl (wilsoft.xs4all.nl [80.127.65.128]) by svr1.postgresql.org (Postfix) with ESMTP id 01118D1B440 for ; Mon, 12 Jan 2004 18:53:32 -0400 (AST) Received: from wilsoft.nl (pentium.wilsoft.nl [192.168.4.5]) (authenticated bits=0) by linux.wilsoft.nl (8.12.9/8.12.9/Debian-5) with ESMTP id i0CMim31030533 for ; Mon, 12 Jan 2004 23:44:48 +0100 Message-ID: <4003235F.9080800@wilsoft.nl> Date: Mon, 12 Jan 2004 23:44:47 +0100 From: ListSrv User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Tablerights for User in Group References: <8utLb.27735$Tz1.15693@news.chello.at> <40030C39.5030806@wilsoft.nl> <20040112212138.GA23970@wolff.to> In-Reply-To: <20040112212138.GA23970@wolff.to> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-WilSoft-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/96 X-Sequence-Number: 11959 Bruno,, Perfect, exactly what I was looking for. It's is also available in version 7.3.x which I use. RTFM , I would say.... :-[ Thanks, Willem Bruno Wolff III wrote: >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. > > >