Read-only and full access permissions

The actions that users can perform on a Derby database are determined by the type of access that users have to the database objects.

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.

Table 1. Actions that are authorized by type of access
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