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 7DC579DCAAE for ; Mon, 27 Feb 2006 08:22:37 -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 11795-05 for ; Mon, 27 Feb 2006 08:22:38 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3DE549DCA20 for ; Mon, 27 Feb 2006 08:22:33 -0400 (AST) Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by svr4.postgresql.org (Postfix) with ESMTP id 3DBEB5AF851 for ; Mon, 27 Feb 2006 12:22:36 +0000 (GMT) Received: from server88-208-192-113.live-servers.net ([88.208.192.113]:40349 helo=webmail.mailnetwork.co.uk) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FDhOb-0001Bv-DX; Mon, 27 Feb 2006 12:22:33 +0000 MIME-Version: 1.0 X-Mailer: X-Mailer: V-webmail 1.6.2 ( http://www.v-webmail.org/ ) In-Reply-To: <4402EC0C.9030903@cleanjohn.net> References: <4402EC0C.9030903@cleanjohn.net> Date: Mon, 27 Feb 2006 12:21:51 +0000 From: "Andy Shellam" Cc: pgsql-admin@postgresql.org Subject: Re: Priviliges and Roles Reply-To: andy.shellam@mailnetwork.co.uk Content-Type: multipart/alternative; boundary="=_b42d966b21b3f6f2ecfc683999e1d91f" Message-ID: To: dayoj@cleanjohn.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.643 required=5 tests=[HTML_00_10=0.642, HTML_MESSAGE=0.001] X-Spam-Score: 0.643 X-Spam-Level: X-Archive-Number: 200602/317 X-Sequence-Number: 20738 --=_b42d966b21b3f6f2ecfc683999e1d91f Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Hi Dayo, This is how I understand it, but I might be wrong: I believe the user who is has permission to execute the function also needs permissions to perform the table writes. Regards Andy Dayo Johnson wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > !DSPAM:14,4402ee2c160447970214199! > > > _________________________________________________________ This mail sent using V-webmail - http://www.v-webmail.org --=_b42d966b21b3f6f2ecfc683999e1d91f Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hi Dayo, This is how I understand it, but I might be wrong: I believe the user who is has permission to execute the function also needs= permissions to perform the table writes. Regards Andy Dayo Johnson wrote: > Hello, >=20 > Is it possible to do the following: > Disallow permission to write to a table (either by UPDATE or INSERT) but= =20 > allow EXECUTE permission on a Function that writes to the table ? >=20 > The reason I want to do this is so that I can perform certain checks on= =20 > the data that is being written before I allow it to be written. >=20 > Cheers DayoJ >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >=20 > !DSPAM:14,4402ee2c160447970214199! >=20 >=20 >=20 --=_b42d966b21b3f6f2ecfc683999e1d91f--