Re: Making "SECURITY DEFINER" procedures.. - SOLVED

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergey Holod <sss(at)radiocom(dot)net(dot)ua>
Cc: pgsql-sql(at)postgresql(dot)org, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Subject: Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Date: 2003-04-30 04:10:37
Message-ID: 19603.1051675837@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Sergey Holod <sss(at)radiocom(dot)net(dot)ua> writes:
> GRANT USAGE ON schema data TO rcbilling;
> Don't fully undestand why I need that, but It works..

Okay, that's the same bug we found just a couple days ago. Schema-usage
errors are checked at query parse time, not execution time, and the
foreign-key triggers weren't being careful to set the right context for
those checks. There's a fix in place for 7.3.3.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-04-30 04:55:24 Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Previous Message ed despard 2003-04-30 04:00:51 rules question