The actions that users can perform on a Derby database is determined by the type of access that users have to the database objects. permissionsread-only access permissionsfull access

The following table lists the actions that users can perform based on the type of access that a user is granted on a database. These actions apply to regular databases, source databases, and target databases.

Action Read-only access Full access Executing SELECT statements X X Reading database properties X X Loading database classes from jar files X X Executing INSERT, UPDATE, or DELETE statements X Executing DDL statements X Adding or replacing jar files X Setting database properties X