It seems to me, I remember something like this. If I do remember correctly, you need the execute permissions for the directory, so it would need to be 775.
Terry -----Original Message----- Sent: Monday, December 03, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi all, I got one problem about UTL_FILE_DIR. My oracle version is 8i 8.1.6 Platform is unix sun solaris. I have set UTL_FILE_DIR to : /customer/ShopA and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA When I execute the PL/SQL job through SQLPLUS, I hit error message saying that I can't write to the directory. the /customer/ShopA directory permission is set to 664. Let's say owner is A, and the group is A1 Can I tell the program to access the directory and write to the file as another user ? If I'm not wrong, the program will try to write into the directory using oracle unix account. Note : I don't want to set the write permission to other group. I have tried to include oracle in A1 group using secondary group, but it couldn't work. Can somebody tell me how to let oracle write into the directory and the file as well without changing the directory / file permission. if I set UTL_FILE_DIR = * would there be any security issue ? Any help will be greatly appreciated. Thanks & Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Herman Susantio INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
