This week's book giveaway is in the iOS forum.
We're giving away four copies of Classic Computer Science Problems in Swift and have David Kopec on-line!
See this thread for details.
Win a copy of Classic Computer Science Problems in Swift this week in the iOS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to set the password for SQLite database? Is it possible to set the password for SQLite database?  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to set the password for SQLite database in windows. Is there any sql command available to set the password in SQLite database? Any suggestions on this
 
Sheriff
Posts: 4838
135
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My understanding is that SQLite is not designed for username and password security, but you can use your operating system's security, because the database is all in one file.  How to proceed depends on your OS.
 
Bartender
Posts: 19362
86
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch!

I did a quick search and found this: https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt

Note that your SQLite database has to be built with authentication enabled for it to work.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!