db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "UserIdentifiers" by DanDebrunner
Date Thu, 25 Oct 2007 18:45:35 GMT
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

------------------------------------------------------------------------------
  || User set as user property in DriverManager connection request ||
  || User name on JDBC URL ||
  || || || ||
- || JDBC !DatabaseMetaData.getUserName || ??? || ||
+ || JDBC !DatabaseMetaData.getUserName() || Returns the user name used to make the JDBC connection
request which is a SQL identifier and not the normal form of the name. || conn.getMetaData().getUserName()
||
  || || || ||
- ||<|2(> Derby BUILTIN authentication ||<|2(> Follows the rules of SQL identifiers
including support for delimited identifiers. || System property derby.user.''username''=''password''
||
+ ||<|2(> Derby BUILTIN authentication ||<|2(> Follows the rules of SQL identifiers
including support for delimited identifiers. [http://issues.apache.org/jira/browse/DERBY-3150
DERBY-3150]  || 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 ||
  
+ == Example - User EVE ==
+ All of these examples are valid for user name EVE
+ || GRANT SELECT ON t TO eve ||
+ || REVOKE SELECT ON T FROM EvE ||
+ || GRANT SELECT ON t TO EVE ||
+ || GRANT SELECT ON t TO "EVE" ||
+ || VALUES CURRENT_USER will return EVE ||
+ || CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS('EVE', NULL) ||
+ || VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS('EVE') ||
+ || jdbc:derby:db;user=eve ||
+ || jdbc:derby:db;user=EVE ||
+ || ds.getConnection("eve", password); // Java code DatabaseMetaData.getUserName() will return
eve ||
+ || ds.getConnection("EVE", password); // Java code DatabaseMetaData.getUserName() will return
EVE ||
+ || CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.EVE', 'password') ||
+ || CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.eve', 'password') ||
+ || derby.database.readOnlyAccessUsers=eve ||
+ 
+ == Example - User eve ==
+ All of these examples are valid for user name eve
+ || GRANT SELECT ON t TO "eve" ||
+ || REVOKE SELECT ON T FROM "eve" ||
+ || VALUES CURRENT_USER will return eve ||
+ || CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS('eve', NULL) ||
+ || VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS('eve') ||
+ || jdbc:derby:db;user="eve" ||
+ || ds.getConnection("\"eve\"", password); // Java code DatabaseMetaData.getUserName() will
return "eve" ||
+ || CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user."eve"', 'password') ||
+ || derby.database.readOnlyAccessUsers="eve" ||
+ 

Mime
View raw message