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 ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.