davidsharples_at_gmail.com (Dave) wrote in
news:be592d55.0411040647.24eddcbe_at_posting.google.com:
> "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?
>
Yes, that is the one.
Received on Fri Nov 05 2004 - 08:57:44 CST