Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 90422 invoked from network); 4 Feb 2007 00:40:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Feb 2007 00:40:40 -0000 Received: (qmail 17824 invoked by uid 500); 4 Feb 2007 00:40:46 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 17389 invoked by uid 500); 4 Feb 2007 00:40:45 -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 17339 invoked by uid 99); 4 Feb 2007 00:40:44 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Feb 2007 16:40:44 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [68.142.229.96] (HELO smtp109.sbc.mail.re2.yahoo.com) (68.142.229.96) by apache.org (qpsmtpd/0.29) with SMTP; Sat, 03 Feb 2007 16:40:34 -0800 Received: (qmail 33817 invoked from network); 4 Feb 2007 00:34:37 -0000 Received: from unknown (HELO ?127.0.0.1?) (ddebrunner@sbcglobal.net@75.24.104.147 with plain) by smtp109.sbc.mail.re2.yahoo.com with SMTP; 4 Feb 2007 00:34:36 -0000 X-YMail-OSG: DX_TvCwVM1l15ZtTKAl1.TaX.CTKvXsMG2l5dtW61a2Ld4h6d91zeefqwc6OY6Zw2b4oY.8uDUay3vgLZT88RZjzjlwRU400TFSB9oIf.iqDW.t7Arjml0tUME8KD1Bfcp8oWJszwfio4CZzNsHyvyoJBn6eprVrQtBvXa4zFbulDK_sBT3mbxKYRILX Message-ID: <45C52A16.7090405@apache.org> Date: Sat, 03 Feb 2007 16:34:30 -0800 From: Daniel John Debrunner User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Derby Discussion Subject: Re: does derby provide SQL access management (grant and revoke permission) References: <45C26DD4.4020407@gmail.com> <45C2726B.2050405@gmail.com> <45C28072.9090108@gmail.com> <45C2882E.9000107@gmail.com> <45C4F7BB.1060006@gmail.com> In-Reply-To: <45C4F7BB.1060006@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org legolas wood wrote: > I have some technical questions, > - What is differences between a database that have SQL authorization and > a database that does not have any SQL authorization? I mean is there any > changes in schema structure? > - Can we create a database with SQL authorization enabled in a server > environment without any property related to SQL authorization in > derby.properties? > - Is it possible to enable sql authorization for a database that is > created without any sql authorization ? > > We have a database that has no SQL authorization because we were not > aware of this future in derby 10.2 and now we want to add SQL > authorization to it. I connect to database using a server that its > derby.properties has all SQL authorization property enabled, but we can > not execute any grant or revoke statement on it. Does this help? http://db.apache.org/derby/docs/10.2/devguide/cdevcsecure866060.html Dan.