Hi Andrew, Turns out SQLite added a user authentication extension in 10/2014 that requires a password to access an SQLite database but it's not part of the SQLite library provided with Livecode. It has to be compiled into the source and a compile time flag set to enable it
See http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt I recently added a QCC request to update the SQLite library which is now about 8 months and several releases old, including the addition of this feature. On Fri Feb 20 2015 at 1:39:32 PM Andrew Kluthe <and...@ctech.me> wrote: > Unfortunately, for a SQLite file there isn't really any built in > authentication/permissions features. > > With using only live code your only real option is to encrypt the entire > file either using built in encrypt/decrypt commands or shell out to > something that can. > > Kind regards, > > Andrew > On Feb 20, 2015 1:53 PM, "JB" <sund...@pacifier.com> wrote: > > > What is the proper way to add a password to > > a MySQL lite database? > > > > John Balgenorth > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
