From: Luis Sousa <llsousa@ualg.pt>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: josh@agliodbs.com, pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Permission on insert rules
Date: Tue, 12 Nov 2002 17:10:32 +0000
Message-ID: <3DD13608.9000100@ualg.pt> (raw)
References: <200211090240.gA92eX412402@candle.pha.pa.us>
Bruce Momjian wrote:
>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.
>
>
>
Offcourse, but when I'm giving permissions to insert and update on
views, I have to give those permissions also to the tables !! (those
operations that are executed on rules)
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, pgman@candle.pha.pa.us
Subject: Re: Permission on insert rules
In-Reply-To: <3DD13608.9000100@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