On 8 Dec 2016, at 12:08pm, 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.

The easiest way to do this is to keep your database file in a folder which has 
the permissions you want.  That way if SQLite creates a new file in that folder 
it automatically has those permissions.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to