Re: rights for schema

On 12/31/2012 05:41 AM, Philipp Kraus wrote:
>
> Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
>

>>
>> Actually as of 9.0 that is not strictly true:
>> http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html
>
> I have create a view for access a table and rules for modifiy the based table. The table has got a trigger.
> If I run an update on the view, I get an error "permission denied" for the trigger call. My user modifies
> only the "view", so do the user also get access to the trigger (execution right)? IMHO the trigger is run
> by postgres self, so the user don't need a right on the trigger.

Was the error for the trigger or the function the trigger called?

>
> Can you explain me the correct accessibility structure of PG?
>
> Phil
>


--
Adrian Klaver
adrian.klaver@gmail.com