utl_file permissions does not have read for others
Oracle version 11.2.0.3
While running the PL/SQL procedure manually, it uses utl_file to create files and the permissions are 644, while running the same PL/SQL using scheduler, the file permissions are 640 and we need read permission for the file to others. The OS is user is not oracle & the database user is the application user.
umask for oracle user is 022
[oracle@ukird181 MiD_LOGFILE]$ umask
0022
File permissions when run from DBMS_SCHEDULER
-rw-r----- 1 oracle dba 27 Jul 18 10:53 File_Permisssion_Test_Job.txt
File permission when PL/SQL is run manually
-rw-r--r-- 1 oracle dba 27 Jul 18 05:50 File_Permisssion_Test.txt
There is no error message, the file gets created in both cases, the difference is in the file permissions. The same thing worked in 11gR1, that is file got created in 11gR1 with 644 permissions while using scheduler as well as while run as a PL/SQL, where as in 11.2.0.3, the file permission is 644 when run as a PL/SQL and 640 while run from scheduler. We want the permission to be 644 when run from scheduler also. Is this some bug with utl_file & scheduler in 11gR2?
While running the PL/SQL procedure manually, it uses utl_file to create files and the permissions are 644, while running the same PL/SQL using scheduler, the file permissions are 640 and we need read permission for the file to others. The OS is user is not oracle & the database user is the application user.
umask for oracle user is 022
[oracle@ukird181 MiD_LOGFILE]$ umask
0022
File permissions when run from DBMS_SCHEDULER
-rw-r----- 1 oracle dba 27 Jul 18 10:53 File_Permisssion_Test_Job.txt
File permission when PL/SQL is run manually
-rw-r--r-- 1 oracle dba 27 Jul 18 05:50 File_Permisssion_Test.txt
There is no error message, the file gets created in both cases, the difference is in the file permissions. The same thing worked in 11gR1, that is file got created in 11gR1 with 644 permissions while using scheduler as well as while run as a PL/SQL, where as in 11.2.0.3, the file permission is 644 when run as a PL/SQL and 640 while run from scheduler. We want the permission to be 644 when run from scheduler also. Is this some bug with utl_file & scheduler in 11gR2?
0