What determines UMASK for Oracle Job using UTL_FILE?
0
votes
1
answer
188
views
A PL/SQL job **foobar622** writes files to UNIX/LINUX server using the following Oracle file I/O commands:
UTL_FILE.FILE_OPEN
UTL_FILE.PUT_LINE
UTL_FILE.FILE_CLOSE
In the past the files had these permissions:
-rw-r--r-- 1 User_foobar_101 UnixGroup_101 563343 Apr 25 00:22 foobar622_fz.sql
-rw-r--r-- 1 User_foobar_101 UnixGroup_101 563343 Apr 25 00:22 foobar622_fa.sql
-rw-r--r-- 1 User_foobar_101 UnixGroup_101 563343 Apr 25 00:22 foobar622_fb.sql
-rw-r--r-- 1 User_foobar_101 UnixGroup_101 563343 Apr 25 00:22 foobar622_fc.sql
-rw-r--r-- 1 User_foobar_101 UnixGroup_101 563343 Apr 25 00:22 foobar622_fd.sql
Now **foobar622** writes with these permissions:
And I get a permission denied
error when I try to open file in my editor.
-rw-r----- 1 Unknown+User Unknown+Group 563343 May 22 00:22 foobar622_fa.sql
-rw-r----- 1 Unknown+User Unknown+Group 563347 May 25 00:22 foobar622_fb.sql
-rw-r----- 1 Unknown+User Unknown+Group 563333 May 25 00:22 foobar622_fc.sql
-rw-r----- 1 Unknown+User Unknown+Group 563923 May 25 00:22 foobar622_fd.sql
How do I go about restoring first default permissions? Is this an Oracle setting or a UMASK setting, or what?
Asked by zundarz
(393 rep)
May 26, 2023, 02:17 PM
Last activity: May 26, 2023, 03:39 PM
Last activity: May 26, 2023, 03:39 PM