The fundamental issue is that the SQLite database format is well known, so while you can compile in the authentication extension to make the program need to authenticate, a program without that extension included has the ability to access the database without the password. Even if all versions of SQLite included this extension, it would still be possible to bypass the password by just compiling a version without the check.
The best way around this issue is to encrypt the database, then only people with the encryption key can access the database. On 5/20/16 6:42 AM, Agarwal, Rajesh wrote: > Not encryption, to password protect the db file. > > Thanks > Rajesh Agarwal > > > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard > Hipp > Sent: Friday, May 20, 2016 4:11 PM > To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> > Subject: Re: [sqlite] Password Protect SQLite DB > > On 5/20/16, Agarwal, Rajesh <Rajesh.Agarwal at snapon.com> wrote: >> Are there any extensions available >> to password protect the SQLite database? > The SQLite Encryption Extension (SEE): http://www.hwaci.com/sw/sqlite/see.html > -- Richard Damon
