Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 47825 invoked from network); 30 Aug 2006 06:32:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Aug 2006 06:32:43 -0000 Received: (qmail 77117 invoked by uid 500); 30 Aug 2006 06:32:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 76907 invoked by uid 500); 30 Aug 2006 06:32:43 -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 76897 invoked by uid 99); 30 Aug 2006 06:32:43 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2006 23:32:43 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2006 23:32:41 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 4966B7142D4 for ; Wed, 30 Aug 2006 06:29:23 +0000 (GMT) Message-ID: <5628258.1156919363297.JavaMail.jira@brutus> Date: Tue, 29 Aug 2006 23:29:23 -0700 (PDT) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Closed: (DERBY-1643) A "revoke execute ... restrict" should fail if there are dependent objects on the execute privilege In-Reply-To: <26553734.1154659933916.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 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 [ http://issues.apache.org/jira/browse/DERBY-1643?page=all ] Mamta A. Satoor closed DERBY-1643. ---------------------------------- Fix Version/s: 10.2.1.0 Resolution: Fixed Closing this issue since I am finished with the work targeted for 10.2 release. The remaining work for this issue is getting tracked in DERBY-1632. I will link the 2 issues so we can keep track of the correlation between the 2 jira entries. > A "revoke execute ... restrict" should fail if there are dependent objects on the execute privilege > ---------------------------------------------------------------------------------------------------- > > Key: DERBY-1643 > URL: http://issues.apache.org/jira/browse/DERBY-1643 > Project: Derby > Issue Type: New Feature > Components: SQL > Affects Versions: 10.2.1.0 > Reporter: Mamta A. Satoor > Assigned To: Mamta A. Satoor > Fix For: 10.2.1.0 > > Attachments: DERBY1643_diff_V1_RevokeExecutePrivilege.txt, DERBY1643_diff_V2_RevokeExecutePrivilege.txt, DERBY1643_stat_V1_RevokeExecutePrivilege.txt, DERBY1643_stat_V2_RevokeExecutePrivilege.txt > > > As per the functional spec attached to DERBY-1330, a "revoke execute ... restrict" should fail if there are dependent objects on the execute privilege > In order to implement this, when revoke execute is executed, a special invalidation action should be sent and dependent objects will need to catch that invalidation and throw an exception. If there are no dependents, then no exception will be thrown and revoke execute will succeed. > I am just creating a new jira entry here so it is easier to track sub items of DERBY-1330. Will link this Jira entry to DERBY-1330. > See the functional spec attached to DERBY-1330 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira