thank you.. how can i use sqlite_db_readonly function..
On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena <[email protected]> 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 <[email protected]> wrote: > >> On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena <[email protected]> >> 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 <[email protected]> >> wrote: >> > >> >> >> >> On 9 May 2014, at 1:23pm, Sky Meena <[email protected]> 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 >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
