From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200211090240.gA92eX412402@candle.pha.pa.us>
Subject: Re: Permission on insert rules
In-Reply-To: <200211081735.01704.josh@agliodbs.com>
To: josh@agliodbs.com
Date: Fri, 8 Nov 2002 21:40:33 -0500 (EST)
Cc: Luis Sousa <llsousa@ualg.pt>,
	pgsql-sql <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Josh Berkus wrote:
> 
> Luis,
> 
> > Just a question.
> > I'm writing some rules to insert/update some data in my database, and I 
> > gave all the privileges on that view to the user, and only select on the 
> > tables.
> > When that user inserts data using the view, I thought that was user 
> > postgres that will do the rest ! But I got  permission denied on those 
> > tables.
> > The idea was to create a layer, with the views, giving to that user 
> > 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 
> am not sure about permissions for updatable views.   Tom, Bruce?

Views have always had their own permissions.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073