PL/SQL - Unix Modify Permission [message #392995] |
Thu, 19 March 2009 23:21 |
wmgonzalbo
Messages: 98 Registered: November 2008
|
Member |
|
|
Hi experts,
Is there a way to modify the permission of the sent files in my directory (My_DIR1) using PL/SQL only, not setting the permission in the OS (UNIX) level?
I need to do this because I get my input files from My_DIR1 (with chmod 777 permission already), then I rename the files that are already processed. I am encountering the error: ORA-29283: invalid file operation, IF i dont set the permission of the input files (through UNIX) to chmod 777 (permit all).
I granted this options to my directory:
GRANT READ, WRITE ON DIRECTORY My_DIR1 TO MySchema WITH GRANT OPTION;
GRANT READ, WRITE ON DIRECTORY My_DIR1 TO SYSTEM WITH GRANT OPTION;
After searching, I encountered that some modify their init.ora,
and adds this
UTL_FILE_DIR=/mypath/insidemypath.
But i believe this doesn't give/modify permission in the OS level? I tried it, and still to no avail.
Is there a way to modify, the OS level permissions of my directory using PL/SQL only, and not writing a java or UNIX shell script? Because that may be my next option if there is no work around here.
Also I'm not sure of the initial permissions of my input files when they will be sent to my directory and I doubt they will have the permission of chmod 777, permit all.
Thanks for the time.
Regards,
Wilbert
|
|
|
|
|
|