[ https://issues.apache.org/jira/browse/DERBY-5363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13085981#comment-13085981 ]
Kathey Marsden commented on DERBY-5363: --------------------------------------- I am just back from vacation and looking at this issue, so my apologies for not speaking up sooner, but I am quite concerned about having a new more restrictive default. I can recall conversations with quite a few different development groups around the requirement that multiple users be able to access the database. I have always told them that as long as the users are in the same group and umask is set appropriately this should work fine. I am concerned about breaking those applications with this change. I think with embedded it is fairly common to have multiple users accessing the database and think the default should be the old behavior and allow the more restrictive file permissions with an option. > Tighten default permissions of DB files with >= JDK6 > ---------------------------------------------------- > > Key: DERBY-5363 > URL: https://issues.apache.org/jira/browse/DERBY-5363 > Project: Derby > Issue Type: Improvement > Reporter: Dag H. Wanvik > Attachments: permission-5.diff, permission-5.stat, permission-6.diff, > permission-6.stat, z.sql > > > Before Java 6, files created by Derby would have the default > permissions of the operating system context. Under Unix, this would > depend on the effective umask of the process that started the Java VM. > In Java 6 and 7, there are methods available that allows tightening up this > (File.setReadable, setWritable), making it less likely that somebody > would accidentally run Derby with a too lenient default. > I suggest we take advantage of this, and let Derby by default (in Java > 6 and higher) limit the visibility to the OS user that starts the VM, > e.g. on Unix this would be equivalent to running with umask 0077. More > secure by default is good, I think. > We could have a flag, e.g. "derby.storage.useDefaultFilePermissions" > that when set to true, would give the old behavior. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira