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 ECE399DC9C5 for ; Mon, 27 Feb 2006 08:16:40 -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 10737-08 for ; Mon, 27 Feb 2006 08:16:43 -0400 (AST) X-Greylist: delayed 00:06:36.227737 by SQLgrey- Received: from smtp101.biz.mail.re2.yahoo.com (smtp101.biz.mail.re2.yahoo.com [68.142.229.215]) by postgresql.org (Postfix) with SMTP id 727DC9DC9B9 for ; Mon, 27 Feb 2006 08:16:36 -0400 (AST) Received: (qmail 12018 invoked from network); 27 Feb 2006 12:09:59 -0000 Received: from unknown (HELO ?127.0.0.1?) (dayoj@cleanjohn.net@196.207.6.39 with plain) by smtp101.biz.mail.re2.yahoo.com with SMTP; 27 Feb 2006 12:09:58 -0000 Message-ID: <4402EC0C.9030903@cleanjohn.net> Date: Mon, 27 Feb 2006 12:09:48 +0000 From: Dayo Johnson Reply-To: dayoj@cleanjohn.net Organization: NCS User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Priviliges and Roles 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 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/315 X-Sequence-Number: 20736 Hello, 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 ? The reason I want to do this is so that I can perform certain checks on the data that is being written before I allow it to be written. Cheers DayoJ