X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2970F475458 for ; Wed, 30 Apr 2003 00:31:39 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 02907475458 for ; Wed, 30 Apr 2003 00:30:57 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3U4AbU6019604; Wed, 30 Apr 2003 00:10:37 -0400 (EDT) To: Sergey Holod Cc: pgsql-sql@postgresql.org, Stephan Szabo Subject: Re: Making "SECURITY DEFINER" procedures.. - SOLVED In-reply-to: <200304300256.02294.sss@radiocom.net.ua> References: <20030429150829.G54888-100000@megazone23.bigpanda.com> <200304300218.08129.sss@radiocom.net.ua> <200304300256.02294.sss@radiocom.net.ua> Comments: In-reply-to Sergey Holod message dated "Wed, 30 Apr 2003 02:56:02 +0300" Date: Wed, 30 Apr 2003 00:10:37 -0400 Message-ID: <19603.1051675837@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-29.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/438 X-Sequence-Number: 13139 Sergey Holod 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