Re: Making "SECURITY DEFINER" procedures.. - SOLVED - Mailing list pgsql-sql

From Tom Lane
Subject Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Date
Msg-id 19603.1051675837@sss.pgh.pa.us
Whole thread Raw
In response to Re: Making "SECURITY DEFINER" procedures.. - SOLVED  (Sergey Holod <sss@radiocom.net.ua>)
Responses Re: Making "SECURITY DEFINER" procedures.. - SOLVED  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Sergey Holod <sss@radiocom.net.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



pgsql-sql by date:

Previous
From: ed despard
Date:
Subject: rules question
Next
From: Stephan Szabo
Date:
Subject: Re: Making "SECURITY DEFINER" procedures.. - SOLVED