Oracle UTL_FILE.fremove (or frename) permission denied

Question

We have a oracle 12.1.0.2 installation on Linux, we have a procedure that read files from a folder, process data and writes file to another folder, and we have all permission required on the folder, so it works up to this point. The problem arise when we try to remove the source file from the starting folder, because the database user has all the the rights on the folder but not on the specific file! Users and suppliers can upload file in this folder via ftp and we couldn't find way to replicate folder permission, I attach a couple of screenshots, please help.

Oracle error is ORA-29283: Invalid file operation Folder Rights

File Rights

score 0 · Answer 1 · answered Jun 07 '18 at 19:28

0

During creation of the files, the permission -rwxr-xr-x might be granted by issuing :

$ chmod 755 test_ftp.xlsx or $ chmod a+x test_ftp.xlsx for related file to be able to be deleted.

answered Jun 07 '18 at 19:28

Barbaros Özhan

59,113
10
31
55

Unfortunately it's not feasible to run chmod after every user operation. – Federico Jun 08 '18 at 08:12
@Federico ok, maybe. Did you try in such a way? – Barbaros Özhan Jun 08 '18 at 08:25
At the moment we have only two users uploading so we set up their Winscp to upload files with the permission needed, it's not exactly the perfect solution but at least it's working. – Federico Jun 08 '18 at 09:23

Oracle UTL_FILE.fremove (or frename) permission denied

1 Answers1