Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 54346 invoked from network); 14 Apr 2009 17:02:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Apr 2009 17:02:00 -0000 Received: (qmail 8512 invoked by uid 500); 14 Apr 2009 17:02:00 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 8429 invoked by uid 500); 14 Apr 2009 17:02:00 -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 8421 invoked by uid 99); 14 Apr 2009 17:02:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 17:02:00 +0000 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 17:01:51 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-2-fe2.eu.sun.com [192.18.6.11]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n3EH1HMh018631 for ; Tue, 14 Apr 2009 17:01:29 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=us-ascii Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7.0-5.01 64bit (built Feb 19 2009)) id <0KI300F00OJ7XI00@fe-emea-10.sun.com> for derby-dev@db.apache.org; Tue, 14 Apr 2009 18:01:17 +0100 (BST) Received: from khepri23.norway.sun.com ([unknown] [129.159.112.235]) by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7.0-5.01 64bit (built Feb 19 2009)) with ESMTPSA id <0KI300G5FOM40RC0@fe-emea-10.sun.com> for derby-dev@db.apache.org; Tue, 14 Apr 2009 18:01:17 +0100 (BST) Date: Tue, 14 Apr 2009 19:01:16 +0200 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: Issues with SQL Roles In-reply-to: <49DE345A.2010908@sbcglobal.net> Sender: Dag.Wanvik@Sun.COM To: derby-dev@db.apache.org Message-id: References: <49DA1113.3060205@sbcglobal.net> <49DE1BA7.4040904@sbcglobal.net> <49DE3288.1020803@Sun.COM> <49DE345A.2010908@sbcglobal.net> User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org Kathey Marsden writes: > Kim Haase wrote: >> >> I can file (and fix) an issue for this if you think it makes sense. >> > Thanks Kim for offering to jump on this. Let's see what folks have to > say about Tiago's comment on this first and determine whether a > behavior change or a change in documentation is most appropriate. I think it would be good to add a possibility to have a default role set on connection (as an option), since this is allowed by the standard in that is implementation defined. Feel free to add an improvement issue to that effect, Tiago! For now, I suggest we just clarify the docs as suggested; an example is good, thanks Kim! Dag