How to change permission of a file created using UTL_FILE.FOPEN?
file-permissions, oracle, sql
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
Problem
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)