X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6ACD29DCACD for ; Mon, 27 Feb 2006 09:40:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23100-07 for ; Mon, 27 Feb 2006 09:40:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp102.biz.mail.re2.yahoo.com (smtp102.biz.mail.re2.yahoo.com [68.142.229.216]) by postgresql.org (Postfix) with SMTP id 4AB479DCAB9 for ; Mon, 27 Feb 2006 09:40:24 -0400 (AST) Received: (qmail 97019 invoked from network); 27 Feb 2006 13:40:28 -0000 Received: from unknown (HELO ?127.0.0.1?) (dayoj@cleanjohn.net@196.207.6.39 with plain) by smtp102.biz.mail.re2.yahoo.com with SMTP; 27 Feb 2006 13:40:26 -0000 Message-ID: <4403013D.7000402@cleanjohn.net> Date: Mon, 27 Feb 2006 13:40:13 +0000 From: Dayo Johnson Reply-To: dayoj@cleanjohn.net Organization: NCS User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Jerry Sievers CC: pgsql-admin@postgresql.org Subject: Re: Priviliges and Roles References: <4402EC0C.9030903@cleanjohn.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/319 X-Sequence-Number: 20740 Jerry Sievers wrote: > Dayo Johnson writes: > > >> Is it possible to do the following: >> Disallow permission to write to a table (either by UPDATE or INSERT) but >> allow EXECUTE permission on a Function that writes to the table ? >> > > Study up on the 'security definer' option in the manual sections on > user defined functions. > > HTH > Thank you, I believe that sorts me out :-) Cheers DayoJ