Permission on insert rules

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Permission on insert rules
Date: 2002-11-08 17:29:31
Message-ID: 3DCBF47B.7080809@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2002-11-08 18:20:02 Time difference without intervals
Previous Message Bruce Momjian 2002-11-08 15:56:43 Re: pg_dump, no inserts but \copy?