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