SQLite Forum

Password protection to database

Password protection to database

(1) By Srujan Reddy (suju814) on 2020-10-06 14:48:44 [source]

Hi All, am facing one issue with the sqlite3 db creation and data protection. Need to protect my sqlite db with the password using python scripting. while creating the DB need to give the password through python script.

(2) By David Raymond (dvdraymond) on 2020-10-06 15:04:47 in reply to 1 [link] [source]

How are you protecting the database? The base SQLite engine doesn't have any password/encryption options. You have to either use the paid SEE option for encryption, or some third party solution.

(3) By Richard Damon (RichardDamon) on 2020-10-06 15:53:30 in reply to 2 [link] [source]

Or to be a bit more explicit, without encrypting the database, it is possible to connect to the database by any program that uses SQLite (like the CLI) and bypass any 'program based' protection. Base SQLite does not include an encryption option. That is availabe as a piad option (SEE) from the suppliers of SQLite, or there are other 3rd party options available.