"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:<Xns959643C65FEA3SunnySD_at_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.
Are you talking about _trace_files_public?
Received on Thu Nov 04 2004 - 08:47:49 CST
