Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 07F5C475F38 for ; Fri, 8 Nov 2002 20:33:54 -0500 (EST) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 64E71475ED1 for ; Fri, 8 Nov 2002 20:33:53 -0500 (EST) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1818709; Fri, 08 Nov 2002 17:36:55 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Luis Sousa , pgsql-sql Subject: Re: Permission on insert rules Date: Fri, 8 Nov 2002 17:35:01 -0800 X-Mailer: KMail [version 1.4] References: <3DCBF47B.7080809@ualg.pt> In-Reply-To: <3DCBF47B.7080809@ualg.pt> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200211081735.01704.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/146 X-Sequence-Number: 10288 Luis, > Just a question. > I'm writing some rules to insert/update some data in my database, and I= =20 > gave all the privileges on that view to the user, and only select on the= =20 > tables. > When that user inserts data using the view, I thought that was user=20 > postgres that will do the rest ! But I got permission denied on those=20 > tables. > The idea was to create a layer, with the views, giving to that user=20 > permission on views to insert and update, and not to tables. > Is this possible ? This is a known problem. I know that permissions for Functions has been addressed in 7.3. However,= I=20 am not sure about permissions for updatable views. Tom, Bruce? --=20 -Josh Berkus Aglio Database Solutions San Francisco