Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 68458 invoked from network); 21 Feb 2007 20:03:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Feb 2007 20:03:31 -0000 Received: (qmail 20277 invoked by uid 500); 21 Feb 2007 20:03:35 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 20251 invoked by uid 500); 21 Feb 2007 20:03:35 -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 20233 invoked by uid 99); 21 Feb 2007 20:03:35 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Feb 2007 12:03:35 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Feb 2007 12:03:26 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 3CD0A7141EF for ; Wed, 21 Feb 2007 12:03:06 -0800 (PST) Message-ID: <24308772.1172088186246.JavaMail.jira@brutus> Date: Wed, 21 Feb 2007 12:03:06 -0800 (PST) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-2264) Restrict shutdown, upgrade, and encryption powers to the database owner In-Reply-To: <21872343.1169502870264.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 [ https://issues.apache.org/jira/browse/DERBY-2264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474813 ] Rick Hillegas commented on DERBY-2264: -------------------------------------- Thanks for the patch, Dag. Committed DERBY-2264-1.diff at subversion revision 510173. The patch looks solid to me and derbyall passes cleanly. Two small points, which you may or may not want to address in a future patch: 1) Grammar: I think that the new error message would read better if you put another "the" in the second sentence. So: "Only the database owner can perform this operation." 2) Style: In DboPowersTest.dboSuite(), the magic array size 3 could be replaced with a constant. > Restrict shutdown, upgrade, and encryption powers to the database owner > ----------------------------------------------------------------------- > > Key: DERBY-2264 > URL: https://issues.apache.org/jira/browse/DERBY-2264 > Project: Derby > Issue Type: New Feature > Components: Security, SQL > Reporter: Rick Hillegas > Assigned To: Dag H. Wanvik > Attachments: dbaPowers.html, dbaPowers.html, DERBY-2264-1.diff, DERBY-2264-1.stat, encrypt-1b.sql, encrypt-2.sql, encrypt-3.sql > > > This JIRA separates out the database-owner powers from the system privileges in the master security JIRA DERBY-2109. Restrict the following powers to the database owner for the moment: shutdown, upgrade, and encryption. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.