Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 96388 invoked from network); 18 Aug 2006 02:55:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Aug 2006 02:55:03 -0000 Received: (qmail 18523 invoked by uid 500); 18 Aug 2006 02:55:03 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 18494 invoked by uid 500); 18 Aug 2006 02:55:03 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 18481 invoked by uid 99); 18 Aug 2006 02:55:03 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Aug 2006 19:55:03 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Aug 2006 19:55:02 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id E61C5D495A for ; Fri, 18 Aug 2006 03:54:41 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Fri, 18 Aug 2006 02:54:41 -0000 Message-ID: <20060818025441.11509.31824@ajax.apache.org> Subject: [Db-derby Wiki] Update of "ReferenceManualTenTwo" by YipNg X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by YipNg: http://wiki.apache.org/db-derby/ReferenceManualTenTwo ------------------------------------------------------------------------------ ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html HTML URL] || Yip || CREATE SCHEMA syntax needs to be updated. The following are also allowed: CREATE SCHEMA schema-name AUTHORIZATION user-name and CREATE SCHEMA AUTHORIZATION user-name. Addtional examples to use these new syntax would be nice. || ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html HTML URL] || Yip || RENAME TABLE needs to address that one can only perform renaming of a table if the user is the database owner or the user have the authorization to the schema of the table to be renamed. || ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html HTML URL] || Yip || LOCK TABLE needs to address that one can only perform locking of a table if the user is the database owner or the user have the proper privilege to execute such an action. This is not covered in the design spec. || + ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html HTML URL] || Yip || The statement "You can create a trigger in any schema except one that starts with SYS." is not longer true when sql authorization is enabled. Need to update this statement to reflect on the Derby SQL authorization model. || [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''