I have this scheduler job, which inturn calls a stored procedure to create a .txt file in NAS location. Although the scheduler job successfully creates the file, nobody other than oracle user is able to open that .txt file.
Oracle user needs to have READ and WRITE privilege on the NAS location, while all others have just READ-ONLY access on that location.
Currently Oracle user has 2775 permission on the NAS directory.
After creating the text file from PL/SQL stored procedure, is there a way to change file permission to 664 from within the PL/SQL stored procedure or dbms_scheduler job itself?
If so, please provide a sample?