Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 82593 invoked from network); 25 Sep 2006 08:54:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Sep 2006 08:54:24 -0000 Received: (qmail 88505 invoked by uid 500); 25 Sep 2006 08:54:24 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 88113 invoked by uid 500); 25 Sep 2006 08:54:23 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 88102 invoked by uid 99); 25 Sep 2006 08:54:23 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 25 Sep 2006 01:54:23 -0700 Authentication-Results: idunn.apache.osuosl.org smtp.mail=andersmo@trapper.coreless.net; spf=permerror X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests= Received-SPF: error (idunn.apache.osuosl.org: domain trapper.coreless.net from 129.241.7.60 cause and error) Received: from [129.241.7.60] ([129.241.7.60:42150] helo=fri.itea.ntnu.no) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id 3B/BE-13750-A3997154 for ; Mon, 25 Sep 2006 01:54:20 -0700 Received: from localhost (localhost [127.0.0.1]) by fri.itea.ntnu.no (Postfix) with ESMTP id 2717A83AB for ; Mon, 25 Sep 2006 10:54:15 +0200 (CEST) Received: from trapper.coreless.net (trapper.fa-s.ntnu.no [129.241.43.241]) by fri.itea.ntnu.no (Postfix) with ESMTP for ; Mon, 25 Sep 2006 10:54:14 +0200 (CEST) Received: from andersmo by trapper.coreless.net with local (Exim 4.63) (envelope-from ) id 1GRmE9-00089r-GC for derby-user@db.apache.org; Mon, 25 Sep 2006 10:54:13 +0200 Date: Mon, 25 Sep 2006 10:54:13 +0200 From: Anders Morken To: Derby Discussion Subject: Re: CREATE SCHEMA schema name AUTHORIZATION username Message-ID: <20060925085413.GE8227@trapper.coreless.net> Reply-To: derby-user@db.apache.org References: <20060925021645.98563.qmail@web53803.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060925021645.98563.qmail@web53803.mail.yahoo.com> X-Header-Virus: I am a header virus, put me in your headers too! User-Agent: Mutt/1.5.13 (2006-08-11) X-Content-Scanned: with sophos and spamassassin at mailgw.ntnu.no. X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N damon leong: > can derby use the > CREATE SCHEMA schema name AUTHORIZATION username ? > > because when i run ij the error say > ERROR 42X01: Syntax error: Encountered "AUTHORIZATION" at line 5, column > 22. I'd guess you're trying to use a feature which is new in 10.2 (SQL Authorization) on an older version of Derby. Which version are you using, and have you made sure that you're referring to the documentation for that version, and not the latest 10.2 docs? -- Anders Morken My opinions may have changed, but not the fact that I am right!