Password Protect a SQLite DB. Is it possible?

by

You can password protect a SQLite3 DB. Before doing any operations, set the password as follows.

SQLiteConnection conn = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
conn.SetPassword("password");
conn.Open();

then next time you can access it like

conn = new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;Password=password;");
conn.Open();

This wont allow any GUI editor to view your data. Some editors can decrypt the DB if you provide the password. The algorithm used is RSA.

Later if you wish to change the password, use 

conn.ChangePassword("new_password");

To reset or remove password, use 

conn.ChangePassword(String.Empty);

More Related Contents:

  1. In sqlite I would do, But how in mongodb c#
  2. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  3. Unable to load DLL ‘SQLite.Interop.dll’
  4. Is there a .NET/C# wrapper for SQLite? [closed]
  5. SQLite Database Locked exception
  6. Adding parameters in SQLite with C#
  7. SQLite Insert very slow?
  8. Create SQLite Database and table
  9. How do I get around the “‘” problem in sqlite and c#?
  10. auto create database in Entity Framework Core
  11. Problems using Entity Framework 6 and SQLite
  12. SQLite .NET performance, how to speed up things?
  13. What is the best way to connect and use a sqlite database from C#
  14. Getting the Last Insert ID with SQLite.NET in C#
  15. How to auto create database on first run?
  16. Create/Use User-defined functions in System.Data.SQLite?
  17. SQLite keeps the database locked even after the connection is closed
  18. Enabling Foreign key constraints in SQLite
  19. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  20. Unable to find the requested .Net Framework Data Provider – SQLite
  21. Visual Studio C# – SQLite.Interop.dll not found
  22. Problem using SQLite :memory: with NHibernate
  23. Encrypt SQLite database in C#
  24. How does the SQLite Entity Framework 6 provider handle Guids?
  25. How to create a password protected database?
  26. SHA1 hashing in SQLite: how?
  27. “Requested URI is invalid” during upload with FtpWebRequest
  28. How to use class name as parameter in C#
  29. Retrieve the respective coordinates of all words on the page with itextsharp
  30. How to dynamically load and unload a native DLL file?

Leave a Comment