Permission on insert rules - Mailing list pgsql-sql

From Luis Sousa
Subject Permission on insert rules
Date
Msg-id 3DCBF47B.7080809@ualg.pt
Whole thread Raw
Responses Re: Permission on insert rules  (Josh Berkus <josh@agliodbs.com>)
Re: Permission on insert rules  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Hello everybody,

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 ?

Thanks in advance.
Luis Sousa

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump, no inserts but \copy?
Next
From: Roberto Mello
Date:
Subject: Time difference without intervals