On 27 May 2019, at 3:33am, Adrian Ho <[email protected]> wrote: > The OP wants *all users* to be able to update (write) the DB via the Tcl > script reading_room.tcl, but *not* by (say) running the SQLite shell or > something else. In your setup, as long as a specific user has write > permissions, *every program* the user runs can write to the DB.
Some work in this thread has been because the file is a SQLite database. But it's not really a SQLite question. It's more about the access/permissions model of Debian 9. What OP wants can be reduced to a simpler situation: "I have a text file. It's on a computer running Debian 9. I want to make sure that this text file can be read/written by multiple people, but that it can be read/written only using this program I wrote." I've never used Debian so I can't solve the problem. But from what little I remember of Linux, one solution is to create a special account for that one operation, and set up that account in a non-standard way. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
