Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 98540 invoked from network); 1 Nov 2005 01:34:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Nov 2005 01:34:10 -0000 Received: (qmail 92464 invoked by uid 500); 1 Nov 2005 01:34:04 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 92421 invoked by uid 500); 1 Nov 2005 01:34:03 -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 92347 invoked by uid 99); 1 Nov 2005 01:34:02 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Oct 2005 17:34:02 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.110.153] (HELO e35.co.us.ibm.com) (32.97.110.153) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Oct 2005 17:33:57 -0800 Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com [9.17.195.11]) by e35.co.us.ibm.com (8.12.11/8.12.11) with ESMTP id jA11XdtG028434 for ; Mon, 31 Oct 2005 20:33:39 -0500 Received: from d03av04.boulder.ibm.com (d03av04.boulder.ibm.com [9.17.195.170]) by westrelay02.boulder.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id jA11XdfJ400588 for ; Mon, 31 Oct 2005 18:33:39 -0700 Received: from d03av04.boulder.ibm.com (loopback [127.0.0.1]) by d03av04.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id jA11XdJn019374 for ; Mon, 31 Oct 2005 18:33:39 -0700 Received: from [127.0.0.1] (dyn9030145215.svl.ibm.com [9.30.145.215] (may be forged)) by d03av04.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id jA11XbeX019332 for ; Mon, 31 Oct 2005 18:33:39 -0700 Message-ID: <4366C536.10703@Sourcery.Org> Date: Mon, 31 Oct 2005 17:30:30 -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: Grant and Revoke ... DERBY-464... References: <435FCD22.3050607@Sourcery.Org> <4366B98F.2090905@debrunners.com> In-Reply-To: <4366B98F.2090905@debrunners.com> 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 I wasn't planning on supporting that... An authorization ID can not revoke a privilege from itself... Same as when an authorization ID tries to GRANT itself some privilege. Satheesh Daniel John Debrunner wrote: >Can those permissions, the owner's, be revoked? > >Ie. if I a create table, can I then revoke DELETE permission on it, from >myself? So that no-one can perform a DELETE. > >Dan. > > > > > >