More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Examples of Java 2 Security Policy Files for embedded Derby
Example 1
/* Grants permission to run Derby and access all */
/* databases under the Derby system home */
/* when it is specified by the system property */
/* derby.system.home */
/* Note derby.system.home must be an absolute pathname */
grant codeBase "file://f:/derby/lib/derby.jar" {
permission java.lang.RuntimePermission "createClassLoader";
permission java.util.PropertyPermission "derby.*", "read";
permission java.io.FilePermission "${derby.system.home}${/}
-", "read,write,delete";
};
Example 2
/* Grants permission to run Derby and access all */
/* databases under the Derby system home */
/* when it defaults to the current directory */
grant codeBase "file://f:/derby/lib/derby.jar" {
permission java.lang.RuntimePermission "createClassLoader";
permission java.util.PropertyPermission "derby.*", "read";
permission java.util.PropertyPermission "user.dir", "read";
permission java.io.FilePermission "${user.dir}${/}-",
"read,write,delete";
};
Example 3
/* Grants permission to run Derby and access a single */
/* database (salesdb) under the Derby system home */
/* Note derby.system.home must be an absolute pathname */
grant codeBase "file://f:/derby/lib/derby.jar" {
permission java.lang.RuntimePermission "createClassLoader";
permission java.util.PropertyPermission "derby.*", "read";
permission java.io.FilePermission "${derby.system.home}${/}*",
"read,write,delete";
permission java.io.FilePermission "${derby.system.home}${/}
salesdb${/}
-", "read,write,delete";
};
(Continued on next question...)
