thank you.. how can i use sqlite_db_readonly function..
On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena <sky.me...@gmail.com> wrote: > i will explain.. i created a sqlite db.. now i should tranfer it also > transfered.. while opening a db it should ask password.. for that while > creating db i should enable some password or read only mode.. > > > On Thu, Jul 17, 2014 at 4:27 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > >> On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena <sky.me...@gmail.com> >> wrote: >> >> > i sent a sqlite db from server to client using c program .. in this >> how i >> > set a password for the db to open in sqlite browser... >> >> In short: you can't. >> >> SQLite does not implement SQL access control (GRANT/REVOKE). The only >> protection you can rely on are the access control features of the >> filesystem the database resides in. >> >> You could buy a licence for the SQLite encryption extension (named SEE), >> <http://www.hwaci.com/sw/sqlite/see.html> , which enable you to encrypt >> the database, but I doubt sqlite browser would be able to open an >> encrypted SQLite database. >> >> Hope this helps >> >> -- >> Regards, >> >> Kees Nuyt >> >> >On Fri, May 9, 2014 at 6:05 PM, Simon Slavin <slav...@bigfraud.org> >> wrote: >> > >> >> >> >> On 9 May 2014, at 1:23pm, Sky Meena <sky.me...@gmail.com> wrote: >> >> >> >> > i working in server client... c program. i need to transfer db from >> >> server >> >> > to client. in udp socket .. i to send a db. >> >> >> >> SQLite does not involve a server or a client. All processing and >> access >> >> of the database is done inside your application. It does not >> communicate >> >> over IP, or use a socket, or anything like that. >> >> >> >> You can write your own server if you want, and many people have. Or if >> >> all you want is to send an entire database, you can use any method >> which >> >> would send a text file from one computer to another. For SQLite, if no >> >> program is accessing a database then the database is just one file. >> >> >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users