apache > db
Apache DB Project
Font size:      

Granting Permissions to Derby

Granting Permissions to Derby

The following section discusses which permissions should be granted to Derby (the code base derby.jar).

See Default Policy Implementation and Policy File Syntax at http://java.sun.com/j2se/1.4.2/docs/guide/security/PolicyFiles.html for more information about creating policy files.

Mandatory Permissions

permission java.lang.RuntimePermission "createClassLoader"

Mandatory. It allows Derby to execute SQL queries and supports loading class files from jar files stored in the database.

permission java.util.PropertyPermission "derby.*", read

Allows Derby to read individual Derby properties set in the JVM's system set. If the action is denied, properties in the JVM's system set are ignored.

Database Access Permissions

permission java.io.FilePermission "directory${/}/-", "read,write,delete"

Allows Derby to manage files within the database that maps to the directory specified. For read-only databases, only the "read" action needs to be granted.

Optional Permissions

permission java.io.FilePermission "${derby.system.home}", "read,write"

Allows Derby to determine the system directory when set by db2j.system.home and create it if needed. If the system directory already exists then only the "read" permission needs to be granted.

permission java.util.PropertyPermission "user.dir", "read"

Permits access to the system directory value if derby.system.home is not set or no permission has been granted to read the derby.system.home property.

permission java.io.FilePermission "${derby.system.home}${/}derby.properties", "read"

Allows Derby to read the system properties file from the system directory.

permission java.io.FilePermission "${derby.system.home}${/}derby.log", "read,write,delete"


permission java.io.FilePermission "${user.dir}${/}derby.log", "read,write,delete"

Only one of these permissions is needed. Permits the application to read, write, and delete to the Derby log file, unless the log has been re-directed. (See the derby.stream.error properties in Tuning Derby for more information.) If one of the requested valid actions is denied, the Derby log will be java.lang.System.err.

Combining Permissions

You might grant one FilePermission that encompasses several, or all, of the permissions described below, instead of separately granting a number of the more specific permissions.

For example:

permission java.io.FilePermission "${derby.system.home}/-", "read,write,delete"

Allows the Derby engine complete access to the system directory and any databases contained in the system directory.

Previous Page
Next Page
Table of Contents