The actions that users can perform on a Derby database are 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 Yes Yes Reading database properties Yes Yes Loading database classes from jar files Yes Yes Executing INSERT, UPDATE, or DELETE statements No Yes Executing DDL statements No Yes Adding or replacing jar files No Yes Setting database properties No Yes