Return-Path: 
 <derby-dev-return-15404-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 21962 invoked from network); 21 Feb 2006 19:19:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 21 Feb 2006 19:19:46 -0000
Received: (qmail 40939 invoked by uid 500); 21 Feb 2006 19:19:45 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 40899 invoked by uid 500); 21 Feb 2006 19:19:45 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 40890 invoked by uid 99); 21 Feb 2006 19:19:45 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Feb 2006 11:19:45 -0800
X-ASF-Spam-Status: No, hits=0.9 required=10.0
	tests=HTML_10_20,HTML_MESSAGE,SPF_PASS,UPPERCASE_25_50
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of msatoor@gmail.com designates
 64.233.182.202 as permitted sender)
Received: from [64.233.182.202] (HELO nproxy.gmail.com) (64.233.182.202)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Feb 2006 11:19:44 -0800
Received: by nproxy.gmail.com with SMTP id i2so798417nfe
        for <derby-dev@db.apache.org>; Tue, 21 Feb 2006 11:19:23 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=edyqq9z2054KhnFykyQNGjnlKIMI9LZCbnTaVmi/kgAZ21RhMvAbBb5BBn5W5z/i5zibAWMeCe/bN0efE13rDDyrEDKqsPgj8gm6k8OquDktXkfMD4TaOXY2rgOCBF/0hO6NhK1XWEt9SUJmC3jTH0TZjrelY9eby/LWIMnJqLg=
Received: by 10.48.127.15 with SMTP id z15mr1574278nfc;
        Tue, 21 Feb 2006 11:19:23 -0800 (PST)
Received: by 10.49.18.3 with HTTP; Tue, 21 Feb 2006 11:19:23 -0800 (PST)
Message-ID: <d9619e4a0602211119tbe2bf80pc97b3ea275a3aa91@mail.gmail.com>
Date: Tue, 21 Feb 2006 11:19:23 -0800
From: "Mamta Satoor" <msatoor@gmail.com>
To: "Derby Development" <derby-dev@db.apache.org>
Subject: Grant/Revoke subtask - EXTERNAL SECURITY DEFINER | EXTERNAL SECURITY
 INVOKER
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11763_30507669.1140549563292"
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_11763_30507669.1140549563292
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

Satheesh has added the parser support for EXTERNAL SECURITY DEFINER |
EXTERNAL SECURITY INVOKER on a routine (function or procedure). eg from
lang/grantRevoke.sql test
CREATE PROCEDURE AUTH_TEST.addUserUtility(IN userName VARCHAR(50), IN
permission VARCHAR(22))
LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL SECURITY INVOKER
EXTERNAL NAME 'org.apache.derby.database.UserUtility.add';

But this information about INVOKER vs DEFINER doesn't get stored in any
system table. I am looking into finishing up this subtask to see what may b=
e
required during compile, execute and upgrade times for this subtask.
Will send more information as I make more progress.

thanks,
Mamta

ps Will it be useful to create a subtask of Derby-464 to keep track of this
work?

------=_Part_11763_30507669.1140549563292
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>Hi,</div>
<div>&nbsp;</div>
<div>Satheesh has added the parser support for EXTERNAL SECURITY DEFINER | =
EXTERNAL SECURITY INVOKER on a routine (function or procedure). eg from lan=
g/grantRevoke.sql test</div>
<div>CREATE PROCEDURE AUTH_TEST.addUserUtility(IN userName VARCHAR(50), IN =
permission VARCHAR(22)) <br>LANGUAGE JAVA PARAMETER STYLE JAVA<br>EXTERNAL =
SECURITY INVOKER<br>EXTERNAL NAME 'org.apache.derby.database.UserUtility.ad=
d
';<br>&nbsp;</div>
<div>But this information about INVOKER vs DEFINER doesn't get stored in an=
y system table. I am looking into finishing up this subtask to see what may=
 be required&nbsp;during&nbsp;compile, execute&nbsp;and&nbsp;upgrade times&=
nbsp;for this subtask. Will&nbsp;send more information as I make more progr=
ess.
</div>
<div>&nbsp;</div>
<div>thanks,</div>
<div>Mamta</div>
<div>&nbsp;</div>
<div>ps Will it be useful to create a subtask of Derby-464 to keep track of=
 this work?</div>

------=_Part_11763_30507669.1140549563292--