Re: rights for schema - Mailing list pgsql-general

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.