O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Authorization

Apache Derby provides the ability to configure user authorization for the system. This can be used to secure default access to all databases in the system. To control access to a particular database, you can set database-level properties that specify which users have full (read-write) access to the database and which users have read-only access to the database. Users that are not specified by either property will inherit the default access to the database, which is full (read-write) access.

To specify the access mode for a database, use the derby.database.default-ConnectionMode property. This property can be set to one of three values:

  • noAccess

  • readOnlyAccess

  • fullAccess (the default)

The following example sets the connection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required