Quoth forforum <[email protected]>, on 2010-10-19 22:32:28 -0700: > 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..
This isn't an SQLite problem; this is an underlying platform problem with the mapping of filesystem metadata (such as security descriptors) on removable media. Do you have similar problems with other files? SQLite doesn't have any intra-file permissions; if the user can write to the file, they can write to the database, and if they can't, SQLite can't do anything about it. You might want to find a suitable forum for your class of operating system and ask them how to write your program to deal with removable media in the way that you would prefer. Note that an empty file is practically speaking a valid empty SQLite 3 database, so if you need to set characteristics of the file before doing the sqlite3_open(), you can open() or CreateFile() it or whatever beforehand. > Thanks in advance ---> Drake Wilson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
