Am 31.12.2012 um 15:54 schrieb Adrian Klaver:
> 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?
ERROR: permission denied for schema usermanagement
usermanagement ist ein schema and the base table calls a function within this
schema, this
checks if the user is super user with
select current_setting('is_superuser') = 'on' into l_issuper;
and checks some other datarows, which stores additional information about the
user
The trigger calls a function "isAdministrator" within the schema.
Thanks
Phil
