Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE permission

Re: UTL_FILE permission

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 05 Nov 2004 14:57:44 GMT
Message-ID: <Xns959846D36BFD8SunnySD@68.6.19.6>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US