On Thu, Dec 8, 2016 at 1:08 PM, Petr Shestov <pshes...@nvidia.com> wrote:

> How do I change default file permissions of SQLite db files on Windows?
> Currently all freshly created DBs allow full access for Everyone. But I
> need to restrict this to current user.
> One option that I tried is to manually create empty file and set required
> permissions. But if using WAL two other files (-shm and -wal) are still
> created with access for everyone.
>

Either you modify the amalgamation you compile yourself,
or you use your own VFS. See

https://www.sqlite.org/c3ref/vfs_find.html
https://www.sqlite.org/c3ref/vfs.html

and at
https://www.sqlite.org/cli.html#special_commands_to_sqlite3_dot_commands_

.vfsinfo ?AUX?         Information about the top-level VFS
.vfslist               List all available VFSes
.vfsname ?AUX?         Print the name of the VFS stack
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to