You can compile SQLite using CreateFile instead of CreateFile2. That doesn't
have the allowed-paths restriction (among other things).
But you won't pass WACK so Store will reject your submission.
The solution is to change CreateFile2 to support removable media w/the
capability check (or some creative equivalent result). This shouldn't be
terribly difficult *in theory* - capabilities are SIDs, so CreateFile2 would
need to (a) know if the target file is on removable media and (b)
AccessCheck(file, capability). That may be the most straightforward solution
(so of course implementation is probably more complex than it sounds :P),
though I can think of other options that could yield the same net result.
It's a good request to make of Windows.
- Howard
This email may contain confidential and privileged information.? Any
unauthorized use is prohibited.? If you are not the intended recipient, please
contact the? sender by reply email and destroy all copies of the original
message.
-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Juan Pablo
Garc?a Coello
Sent: Sunday, June 28, 2015 11:58 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] RemovableStorage in UWP for SQLite database -
sqlite3_open_v2 issue
In one way I am happy to know that there is people having a great knowledge
about these matters.
At this moment I am sure that compiling and testing if it is possible to use
that method will take me a lot of time and I do not know how much time it take.
Does any have the capability to try to compile using the CreateFile or
StorageFile? I know that is not a simple task, thank you anyway the answers.
Here in the islands the gas and the small quakes are measured using dataloggers
in the natural galleries to be analyzed with data, and Windows 10 IoT is not
such an option? It is sad I have to said.
Thanks Juan Pablo
-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin
Sent: 29 June 2015 07:42
To: General Discussion of SQLite Database
Subject: Re: [sqlite] RemovableStorage in UWP for SQLite database -
sqlite3_open_v2 issue
On 29 Jun 2015, at 7:29am, Juan Pablo Garc?a Coello <juanpablo at
expediteapps.com> wrote:
> Thank you for your really specific answer, I will go to the IoT forum,
> insider, etc to make the request.
Don't bother. They won't change it. The inability to access these places is
intentional. It means that programs can't read each-other's files so malware
programs (e.g. spyware, ransomeware) don't work. This API is similar to what
is available on mobile platforms (e.g. Android, iPhone) where it is extremely
important that one program cannot interfere with another.
The question that interests me is why SQLite uses CreateFile2. I know nothing
about this platform, but CreateFile exists and StorageFile exists, and don't
have the restrictions. But perhaps CreateFile2 is the obvious thing to use
here for some reason.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
