On Tue, 19 Oct 2010 22:32:28 -0700 (PDT), forforum <[email protected]> wrote:
> > Hi, > I am using sqlite DB and am creating my DB in USB drive(this is my > application requirement), My problem is that. when am creating my DB as a > admin in 1 system and taking the same USB in 2nd system who is having > limited rights, then 2nd system user is getting Read only Database > exception, > So i want to ask is there any access rights for Sqlite DB, so that where > ever i will carry my DB it should get update regardless of access rights.. As Drake Wilson already said, this is an underlying platform problem with the mapping of filesystem metadata (such as security descriptors) on removable media. Relevant metadata is ownership and ACL's. The easiest way to solve your problem is to format the USB stick as a FAT filesystem, not NTFS. Other than the "readonly" bit (which is not set on your database file) FAT doesn't support ownership, nor ACL's. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
