Hi,
When installing (compiling) and loading the ROracle package (ROracle_1.3-2.tar.gz) with R4.3 I obviously run into permission issues when loading the library. (In general, I was following the instructions documented in this post https://forums.oracle.com/ords/apexds/post/roracle-for-r-4-0-0-or-newer-3791)..) As suggested there I used the command remotes::install_local("C:/projects/_Rpackages_custom/ROracle_1.3-2.tar.gz", repos = NULL, type = "source")
and tried different approaches:
- Default: Compiling ROracle stops very late when testing library loading where an LoadLibrary error is thrown ("unable to load shared object ‘C:/Users/<…>/AppData/Local/R/win-library/4.3/00LOCK-ROracle/00new/ROracle/libs/x64/ROracle.dll’: LoadLibrary failure")
- Compiling without testing library loading, i.e., add the option
INSTALL_opts = “--no-test-load”
to the install_local()
command above: Now, compilation runs smoothly to the end without errors. Loading the library, however, throws an error ("unable to load shared object 'C:/Users/<…>/AppData/Local/R/win-library/4.3/ROracle/libs/x64/ROracle.dll': LoadLibrary failure: Zugriff verweigert" [Access denied]). I checked the file permissions of the ROracle.dll but couldn't see any difference compared to other libraries in my local user library of R packages.
- Running RStudio with admin rights: Package compilation incl. testing of library loading runs smoothly but then I cannot load the library when running RStudio as a normal user
To sum up, installation basically works fine but during this procedure a permission seems to be set which then prevents from library loading as a normal user.
Any idea how to resolve this? Either avoid that these permissions are set during installation or appropriately modifying permissions afterwards in the library?
Thanks in advance,
Tobi