On Oct 28, 2008, at 5:25 PM, Daniel Stutzbach wrote: > I'm running into an odd problem on Windows Vista relating to > permissions. > I've got a small (77 KB) sqlite DB owned by Administrator. When I > access it > as Administrator, everything works fine. If I try to access it as a > normal > user... things get funky. This is what I observe using the sqlite > command-line tool as a normal user: > > - .schema works > - .dump shows all of the CREATE commands, and 3 INSERT commands > (although > there are more than 100 rows in the DB) > - SELECT shows the same 3 rows. Most tables appear empty. > - No errors are generated > > Again, if I run the command-line tool as Administrator, all of the > data > appears as expected. > > I don't mind if sqlite is unable to read a file due to permissions > making it > impossible, but the fact that it reports success and gives me only > partial > information is driving me bonkers. Any ideas for a work-around, > other than > checking the Windows permissions by hand? >
In order to provide a work-around we need to understand the problem. I have no explanation for the observed behavior. Have you tried running "PRAGMA integrity_check" against the database as a normal user? D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
