[Db-derby Wiki] Update of "UserIdentifiers" by DanDebrunner

[Apache Wiki <wi...@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

New page:
= User Identifiers in Derby =

|| '''Context'''  || '''Definition''' || '''Use''' ||
||<|2(> SQL identifiers ||<|2(> User identifier is a SQL identifier, section 5.4 SQL 2003. A regular identifier is upper-cased, e.g. eve, eVe and EVE all represent the user EVE. A delimited identifier (with double quotes) does not have any case conversion, 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.  This document uses the term ''natural user name'' to represent the represented user name. E.g. eVe is the natural user name for "eVe". The natural 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 natural user name for the current user. E.g. returns eVe for the user eVe and EVE for the user EVE. || VALUES CURRENT USER ||
|| || || ||
||<|2(>  SQL Routine ||<|2(>  A system SQL routine requires the caller pass in the natural 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(> ??? || 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 || ??? || ||
|| || || ||
|| derby.* properties || ??? || ||