Can oracle read local files when only associated by secondary group?
I have a similar problem with DIRECTORY and external tables where linux group access is seemingly ignored. I was able to solve by using an acl and letting the oracle user have the rights it needs while letting the ownership of the file stay will another user.
ll test.txt-rwx------. 1 lunc users 940 Jun 13 09:34 test.txtsetfacl -m u:oracle:rwx test.txtgetfacl test.txt# file: test.txt# owner: lunc# group: usersuser::rwxuser:oracle:rwxgroup::---mask::rwxother::---ll test.txt-rwxrwx---+ 1 lunc users 940 Jun 13 09:34 test.txt
Oracle accepts this (at least for external tables) and is able to access the file.