derby.connection.requireAuthentication

Function

Turns on user authentication for Derby.

When user authentication is turned on, a connection request must provide a valid user name and password.

Derby uses the type of user authentication specified with the derby.authentication.provider property.

For more information about user authentication, see "Working with User Authentication" in Chapter 7 of the Java DB Developer's Guide.

Default

False.

By default, no user authentication is required.

Example

-- system-wide property
derby.connection.requireAuthentication=true
-- database-wide property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
    'derby.connection.requireAuthentication',
    'true')

Dynamic or static

Static. For system-wide properties, you must reboot Derby for the change to take effect. For database-wide properties, you must reboot the database for the change to take effect.