UTL_FILE unable to provide 644 permission to one PDB , no issue in another PDB in same server
Hi
I have found very strange thing here, in same server 2 different container. one is working fine and other is not.
does anyone face this type of issue or any solution available ?
this db HBSGPSNG is creating file 644 while HBSGPGCD is creating file 640 permission.
[oracle@hk01lsngdbd01vp ~]$ sqlplus riz/xxxxxx@HBSGPGCD
SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 19 11:56:04 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> DECLARE
out_File UTL_FILE.FILE_TYPE;
BEGIN
out_File := UTL_FILE.FOPEN('RFILE_DATA', 'test19102020.txt' , 'W');
UTL_FILE.PUT_LINE(out_file , 'Testing!');