How to change permission of a file created using UTL_FILE.FOPEN?

Question

I have an oracle procedure which creates a text file using the UTL_FILE.FOPEN function. The file is created with permission 660. How can I change the permission of the file without using chmod?(I don't have access to the server)

Solution

You could change the umask of the Unix user that owns the Oracle process (resp. ask the system administrator to perform this task for your), see

UTL_FILE permissions