Return-Path: 
 <derby-dev-return-26467-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 89802 invoked from network); 10 Aug 2006 00:42:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 10 Aug 2006 00:42:01 -0000
Received: (qmail 72809 invoked by uid 500); 10 Aug 2006 00:42:00 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 72777 invoked by uid 500); 10 Aug 2006 00:42:00 -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 72768 invoked by uid 99); 10 Aug 2006 00:42:00 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Aug 2006 17:42:00 -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; Wed, 09 Aug 2006 17:41:59 -0700
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id CE3DF7141F0
	for <derby-dev@db.apache.org>; Thu, 10 Aug 2006 00:39:14 +0000 (GMT)
Message-ID: <14062811.1155170354773.JavaMail.jira@brutus>
Date: Wed, 9 Aug 2006 17:39:14 -0700 (PDT)
From: "Deepa Remesh (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1582) REVOKE statement does not generate a
 warning when no privileges are revoked.
In-Reply-To: <3371505.1153804753838.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-1582?page=all ]

Deepa Remesh updated DERBY-1582:
--------------------------------

    Derby Info:   (was: [Patch Available])

Thanks Dan for looking at the patch.

>From what I had tried, I had found that we have to keep track if any privilege is revoked in TablePrivilegeInfo itself as addRemovePermissionsDescriptor is called multiple times in TablePrivilegeInfo.executeGrantRevoke method. Because of this, we need to track whether or not any privilege is revoked for table and routine separately. And we cannot move the whole check to super class.

I think I should have added a common method to check and raise a warning if needed. I'll upload a revised patch.

Please let me know if this doesn't sound okay.

> REVOKE statement does not generate a warning when no privileges are revoked.
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-1582
>                 URL: http://issues.apache.org/jira/browse/DERBY-1582
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.0.0
>            Reporter: Daniel John Debrunner
>         Assigned To: Deepa Remesh
>         Attachments: d1582_v1.diff, d1582_v1.status
>
>
> SQL 2003 standard, section 12.7 <revoke statement>, item 17 under general rules indicates the statement completes with the condition 'warning ? privilege not revoked.' when no matching privilege is revoked.

-- 
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