Function
Has two uses:
Important: Derby's
BUILTIN authentication mechanism is suitable only for development and testing
purposes. It is strongly recommended that production systems rely on LDAP or a
user-defined class for authentication. It is also strongly recommended that
production systems protect network connections with SSL/TLS.
Users and Passwords
This property creates valid clear-text users and passwords within
Derby when the
derby.authentication.provider property is set to BUILTIN. For
information about users, see "Working with user authentication" in the
Derby Developer's Guide.
- Database-Level Properties
When you create users with
database-level properties, those users are available to the specified database
only.
You set the property once for each user. To delete a user, set that user's
password to null.
- System-Level Properties
When you create users with system-level
properties, those users are available to all databases in the system.
You set the value of this system-wide property once for each user, so you can
set it several times. To delete a user, remove that user from the file.
You can define this property in the usual ways -- typically in the
derby.properties file.
When a user name and its corresponding password are provided in the
DriverManager.getConnection call,
Derby validates them against
the properties defined for the current system.
User names are SQL92Identifiers and can be delimited.
Syntax
derby.user.{UserName=Password} | UserName=userDN }
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.user.UserName',
'Password | userDN')
Example
-- system-level property
derby.user.guest=java5w
derby.user.sa=Derby3x9
derby.user."!Amber"=java5w
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.user.sa',
'Derby3x9')
-- cache a userDN locally, database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.user.richard',
'uid=richard, ou=People, o=ExampleSite.com')
Dynamic or static
Dynamic; the change takes effect immediately. For information about dynamic
changes to properties, see
Dynamic and static properties.
