Hi,

I'm having a permission issue with SQLite on my institution's computing grid/cluster.

When I create a file using touch (or any other program for that matter, it correctly receives '-rw-rw----' as the permission. However, when I create it from SQLite, it gets created with '-rw-r-----' (group does not get write permissions, even if it should get them).

I've confirmed this both from the command line client (demonstration script below) and from RSQLite (the SQLite library for R, demonstration script is longer but could attach if anyone thinks it helps).

I've checked with my admins, and they tell me that there was nothing unusual about how SQLite was installed. Any ideas for what could be the cause of this? It seems that to override the umask setting, SQLite must be doing something explicitly, right?

############################
## Reproduction script below

HOSTNAME [TestPermissions]$ umask
0007
HOSTNAME [TestPermissions]$ ll
total 0
HOSTNAME [TestPermissions]$ touch TouchedFile.txt
HOSTNAME [TestPermissions]$ sqlite3 DatabaseFile.sqlite
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .tables
sqlite> .quit
HOSTNAME [TestPermissions]$ ll
total 0
-rw-r----- 1 mtorfason faculty 0 Sep 22 10:07 DatabaseFile.sqlite
-rw-rw---- 1 mtorfason faculty 0 Sep 22 10:07 TouchedFile.txt

## End reproduction script
############################

Best,
Magnus
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to