Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 32980 invoked from network); 9 Mar 2006 15:24:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Mar 2006 15:24:59 -0000 Received: (qmail 91731 invoked by uid 500); 9 Mar 2006 15:24:58 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 91709 invoked by uid 500); 9 Mar 2006 15:24:58 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 91700 invoked by uid 99); 9 Mar 2006 15:24:58 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Mar 2006 07:24:58 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.146] (HELO e6.ny.us.ibm.com) (32.97.182.146) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Mar 2006 07:24:57 -0800 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [9.56.227.234]) by e6.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id k29FOZCZ009115 for ; Thu, 9 Mar 2006 10:24:35 -0500 Received: from d01av02.pok.ibm.com (d01av02.pok.ibm.com [9.56.224.216]) by d01relay02.pok.ibm.com (8.12.10/NCO/VER6.8) with ESMTP id k29FOY8D089118 for ; Thu, 9 Mar 2006 10:24:34 -0500 Received: from d01av02.pok.ibm.com (loopback [127.0.0.1]) by d01av02.pok.ibm.com (8.12.11/8.13.3) with ESMTP id k29FOYB0001925 for ; Thu, 9 Mar 2006 10:24:34 -0500 Received: from [127.0.0.1] (sig-9-48-112-148.mts.ibm.com [9.48.112.148]) by d01av02.pok.ibm.com (8.12.11/8.12.11) with ESMTP id k29FOVvf001519 for ; Thu, 9 Mar 2006 10:24:34 -0500 Message-ID: <4410483B.4070505@Sourcery.Org> Date: Thu, 09 Mar 2006 07:22:35 -0800 From: Satheesh Bandaram User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: SYSTEMALIAS flag in SYSALIASES table References: <440F4C1C.2090402@Sourcery.Org> <440FB4DE.3090704@apache.org> In-Reply-To: <440FB4DE.3090704@apache.org> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Daniel John Debrunner wrote: >What's the effect of the EXTERNAL SECURITY INVOKER/OWNER flag when the >sql standard grant/revoke mode is not enabled? > >Will the EXTERNAL SECURITY INVOKER/OWNER clauses be accepted on the >CREATE FUNCTION/PROCEDURE when the sql standard grant/revoke mode is not >enabled? > > Current functional spec is not clear on this... sqlStandard mode has DEFINER as the default if not specified and non sqlStandard mode uses INVOKER model. It may be best to not allow this flag in current mode. Also non sqlStandard mode will not support DEFINER mode. Satheesh >Dan. > > > > >