Read-only and full access permissions

The actions that users can perform on a Derby database is 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	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