Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #884: Schema access not inherited by functions declared SECURITY DEFINER - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #884: Schema access not inherited by functions declared SECURITY DEFINER
Date
Msg-id 22583.1043441634@sss.pgh.pa.us
Whole thread Raw
In response to Bug #884: Schema access not inherited by functions declared SECURITY DEFINER  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> When calling a function declared SECURITY DEFINER, I get permission
> denied errors on schemas that the function would access.

This is hard to believe.  Please give a complete example.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #885: Trouble with timestamps after vacuuming
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #886: jdbc "update row" can mess up other columns