Re: Bug #884: Schema access not inherited by functions declared SECURITY DEFINER

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jalonso(at)mit(dot)edu, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #884: Schema access not inherited by functions declared SECURITY DEFINER
Date: 2003-01-24 20:53:54
Message-ID: 22583.1043441634@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-01-24 23:46:26 Bug #886: jdbc "update row" can mess up other columns
Previous Message Tom Lane 2003-01-24 20:50:43 Re: Bug #885: Trouble with timestamps after vacuuming