Re: UTL_FILE permission

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 03 Nov 2004 14:39:45 GMT
Message-ID: <Xns959643C65FEA3SunnySD@68.6.19.6>

jiayng_at_yahoo.com (KelisaLee) wrote in
news:8ce04043.0411022320.28e62a2f_at_posting.google.com:

> I've tried to use utl_file.fopen function to write a file to server.
> When i check on attributes of the file, the file is generated by
> oracle user with the priviledge -rw------. However, I need the file to
> be accessed by group and others. Is there a way to chmod upon
> generating the file? Any setting can be done on the server side?

There is (undocumented?) initSID.ora parameter which results in the file protection mask to be 644; but should be used with extreme caution since it can introduce a security risk to the Oracle DB environment. Received on Wed Nov 03 2004 - 08:39:45 CST