On Tue, Jan 8, 2013 at 2:17 PM, Simon Slavin <[email protected]> wrote: > On 7 Jan 2013, at 4:46pm, sants87 <[email protected]> wrote: > >> Hi I am using Sqlite3 for my application and I require to lock the database >> from any third party modification. Accessing database is fine but I don't >> want others to modify the same. i tried Sqlite encryption but that is not >> available for free. Is there other ways to achieve the same? > > There's nothing magical about SQLite database format: > you can open the file with a text editor and replace characters in it. > It may be that rather than look for a solution in SQLite you need > to use your operating system's abilities to prevent a user from changing it.
Perhaps Santosh meant other SQLite-using 3rd party apps, as opposed to anyone able to modify the DB file as you mentioned. If that the case, a BEGIN IMMEDIATE TRANSACTION might be enough for his purpose? See http://www.sqlite.org/lang_transaction.html --DD _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
