From derby-commits-return-8660-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Thu Oct 25 17:55:56 2007 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 55473 invoked from network); 25 Oct 2007 17:55:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Oct 2007 17:55:56 -0000 Received: (qmail 97591 invoked by uid 500); 25 Oct 2007 17:55:43 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 97519 invoked by uid 500); 25 Oct 2007 17:55:43 -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 97508 invoked by uid 99); 25 Oct 2007 17:55:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Oct 2007 10:55:43 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Oct 2007 19:56:37 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id D0A5059A07 for ; Thu, 25 Oct 2007 17:55:32 +0000 (GMT) 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: Thu, 25 Oct 2007 17:55:32 -0000 Message-ID: <20071025175532.25527.47219@eos.apache.org> Subject: [Db-derby Wiki] Update of "UserIdentifiers" by DanDebrunner X-Virus-Checked: Checked by ClamAV on apache.org 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 DanDebrunner: http://wiki.apache.org/db-derby/UserIdentifiers ------------------------------------------------------------------------------ ||<|2(> SQL identifiers ||<|2(> User identifier is a SQL identifier, section 5.4 SQL 2003. A regular identifier is upper-cased to its normal form, e.g. eve, eVe and EVE all represent the user EVE. A delimited identifier (with double quotes) does not have any case conversion to its normal form, e.g. "eVe" represents the user eVe. Note that the delimited identifier "EVE" represents the user EVE which is the same user as the regular identifiers eve, EVE and EvE etc. The normal user name represents how a user name is stored/processed by the SQL engine in a SQL context, e.g. the system tables representing granted permissions. Note that derby.* properties are not in the SQL context. || grantee in GRANT statement || || grantee in REVOKE statement || || || || || - || CURRENT USER expression || Returns the normal user name for the current user. E.g. returns eVe for the user eVe and EVE for the user EVE. || VALUES CURRENT USER || + ||<|3(> CURRENT USER expression ||<|3(> Returns the normal user name for the current user. E.g. returns eVe for the user eVe and EVE for the user EVE. || VALUES CURRENT USER || + || VALUES SESSION_USER || + || VALUES {fn user()} || || || || || - ||<|2(> SQL Routine ||<|2(> A system SQL routine requires the caller pass in the normal user name, this is to align with the value being passed in from CURRENT USER or a value obtained from a system table representing a user. || SYSCS_UTIL.SYSCS_SET_USER_ACCESS [http://issues.apache.org/jira/browse/DERBY-3095 DERBY-3095] || + ||<|2(> SQL Routine ||<|2(> A system SQL routine taking a USERNAME parameter requires the caller pass in the normal user name, this is to align with the value being passed in from CURRENT USER or a value obtained from a system table representing a user. || SYSCS_UTIL.SYSCS_SET_USER_ACCESS [http://issues.apache.org/jira/browse/DERBY-3095 DERBY-3095] || || SYSCS_UTIL.SYSCS_GET_USER_ACCESS [http://issues.apache.org/jira/browse/DERBY-3095 DERBY-3095] || || || || || ||<|3(> JDBC Connection request ||<|3(> Follows the rules of SQL identifiers including support for delimited identifiers. || User named passed into method call, e.g. DataSource.setUser, DriverManager.getConnection || || User set as user property in DriverManager connection request || || User name on JDBC URL || || || || || - || JDBC DatabaseMetaData || ??? || || + || JDBC !DatabaseMetaData || ??? || || || derby.* properties || ??? || || + || || || || + ||<|2(> Derby BUILTIN authentication ||<|2(> Follows the rules of SQL identifiers including support for delimited identifiers. || System property derby.user.''username''=''password'' || + || CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.user.username', 'password') || || || || || ||<|2(> Connection authorization ||<|2(> User names set in Java or database properties. Documented as following the rules of SQL identifiers including support for delimited identifiers. Thus derby.database.fullAccessUsers=eVe and derby.database.fullAccessUsers=EVE have identical meaning. || derby.database.fullAccessUsers || || derby.database.readOnlyAccessUsers ||