When I create a DBSQL sql database the "-journal" directory get a default permission of 777 and not using the umask set on the enviroment. Looking into the source code sqlite3.c, I find that 777 permission is hard coded into the os_mkdir function.
Is there a particular reason why this default permission is set? Is there a way to override this permission level through the api?
As a part of security we do not want everyone to have access to this directory. Please let us know if there is way around this problem.