Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 265 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 229 Portuguese
SQL Developer can't read files from the /Users/<user name>/Documents folder in Mac OS
Folks,
I am at a lost and I need some help. I download the latest SQL Developer for Mac, explode the .zip file and I have the SQLDeveloper.app file (well, folder technically in Mac). I then Copy and Paste this into my Application directory and start up the app. Everything runs fine until when I try to open my .sql files or anything in my /Users/<username>/Documents folder.
I know that Mac OS Catalina has new security model where you suppose to grand access to the Documents or Download folder by app. But my previous version runs just fine without this setup. Also, I have tried to grant SQL Developer Full Disk access in the security setting and it is still not working. When I select File -> File Open and then click on the /Users/<user name>/Documents folder, I am getting the following error message:
I/O error:
The directory /Users/<user name>/Documents is not accessible. Please select a different directory.
The strange thing is that I can select files from the /Applications folder or anywhere else except my own user document folder.
I have even tried to grand the JDK java program full disk access and it is still not working properly.
I also have the same issue with the Oracle DataModeler app as well.
Has anyone seen something like this? Any help is greatly appreciated. Thanks in advance.
Best Answer
-
He means /bin/bash
To add:
- open security and privacy systems preference pane
- click the lock and unlock
- click on "Full Disk Access" on the left panel
- click the + button to add an app
- In the dialog panel that opens up, type "/" to get the "Go to the folder:" panel to pop up
- type in "/bin/bash" there and click on open
And good catch. This does work around the issue. It used to work fine on my Mac but has since stopped working properly. In my case, I thought perhaps due to a java update that was applied. I don't want to really grant full system access to bash either...
I see multiple points that could be the issue:
- Use of bash when Apple has changed default to zsh so perhaps the bash shell is no longer being treated specially by Apple
- I have both OpenJDK 8 and 11 installed and do switch between them so perhaps the permissions granted gets confused between the 2 java runtimes
- Bugs in general with Apple's permissions system
- The mess of processes needed to set the environment up before launching java
Answers
-
I also tried SQL Developer 19.x version and it is still behaving the same way. Any help is greatly appreciated. Thanks
-
Has anyone seen something like this?
I use SQLDev on macOS 10.15.7 and cannot reproduce this issue. Tried with 20.2, 19.4, 19.2.1.
I know that some users had issues when they used a non-default uid (e.g. 502, default is 501). You can get your uid with following command in a terminal window:
id -u
I have a separate user with a non default uid (503). I could open files of that user in the Document folder, but of course access to the other user with the default uid (501) was denied. I suggest to check the uid information of the file and directory with
ls -ln
If the owner uid and the user uid are the same, then I'm running out of ideas.
-
Philipp,
Thanks for your suggestion. My uid 502 is the same as the one listed next to the directory when I do the ls -ln.
I may need to completely remove SQL Developer including any hidden folder and re-install from scratch again. It has worked before in the past and I don't know which sequence of events changes this. I don't use the tool too often enough to notice the difference on a regular basis.
Thanks for your response anyway.
-
Ok, some more updates. If I just double click the SQLDeveloper.app application icon in the Finder window under Applications, it starts, but with no access to the Document folder.
However, if I start a Terminal window, cd to /Applications/SQLDeveloper.app/MacOS/ directory and do the ./sqldeveloper command, that session will start SQL Developer properly and it will have access to the Document folder.
Also, after I grant /usr/bash Full Disk access, this seems to solve the issue where I can just click the SQLDeveloper app icon in the Finder and it will work as expected. But I don't want bash to have full disk access even though technically, this one is owned by "root".
But I don't want to grant /usr/bash Full Disk access in this fashion and I should not need to. Can anyone shed some lights on this please? Thanks
-
I did some further experiments. When I deny Java the access to the "Documents" folder then I do not see any files via File -> Open... . or in the Files view (in the Documents folder). However I can drag & drop a file from the Finder into an open worksheet. That works.
When I check "Documents Folder" in the dialog above, then I can see all files in the Documents folder via File -> Open... in SQL Developer.
I guess in your case the grant to "Documents Folder" is not given. And for some reason macOS does not ask for it anymore.
-
In my case, the Java is already checked for accessing Document folder. But I don't know which version of Java though. Also, strangely, in my case, it only shows that Document folder is available to check, not Desktop and Download folders.
I cannot manually add the program to the Document and Files section. I can do this with the Full Disk Access. Go figure on the Mac side...:(
Anyway, thanks for checking into this. I may just keep the bash grant for now to get around it. I am also wondering if there is a plist file somewhere in the Mac that I can update or review to see if the Java program that is checked is indeed the right Java program.
-
I am facing the same problem. Provided Full Disk Access to both SQL Developer and Java but still unable to access Desktop, Documents and Downloads from SQL Developer 19.2.1.247
Previously, it was working fine for macOS Catalina.
-
When I tried this, it prompted me for permission, I said 'yes' and then the export worked as expected.
-
Thanks, I tried with 20.2 as well but I faced same behavior. I even tried to provide access to SQL Developer following Full Disk Access in Preferences>Security and Privacy.
-
Folks,
So far, the only way that I can get around this issue is to do this:
I grant /bin/bash Full Disk access, this seems to solve the issue where I can just click the SQLDeveloper app icon in the Finder and it will work as expected.
But I don't need to do this in the past. Hope this helps some. Thanks
