From: Luis Sousa <llsousa@ualg.pt>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Permission on insert rules
Date: Fri, 08 Nov 2002 17:29:31 +0000
Message-ID: <3DCBF47B.7080809@ualg.pt> (raw)
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
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: llsousa@ualg.pt
Subject: Re: Permission on insert rules
In-Reply-To: <3DCBF47B.7080809@ualg.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox