From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: rights for schema |
Date: | 2012-12-31 14:54:59 |
Message-ID: | 50E1A743.8080906@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-12-31 15:37:37 | Re: Picking the first of an order in an aggregate query |
Previous Message | Jack Christensen | 2012-12-31 14:43:39 | Re: Picking the first of an order in an aggregate query |