Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE-Package
It doesn't invalidate unix security. It just means that utl_file can write
to anywhere as long as its in the unix permission bounds. The tool cannot
override an operating system.
Mark
Kevin A Lewis wrote in message ...
>You may like to look at the documentation around the Oracle Parameter
>
>UTL_FILE_DIR
>
>but avoid * as this invalidates all UNIX security
>
>Regards
>
>--
>Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>Paul Q <paulq_at_home.com> wrote in message
>news:DAN83.7701$Yr2.124726_at_news2.rdc1.on.home.com...
>> Make sure file read permissions are available to all
>> chmod 444 file
>>
>> mme wrote in message <7k06vu$t8n$2_at_news00.btx.dtag.de>...
>> >Hi all of you!
>> >
>> >I´m experiencing problems using the UTL_FILE package.
>> >Creating textfiles isn´t a problem, but reading textfiles. ORA
>> >always reports "error opening file". I´ve checked the
>> >rights and stuff (Unix) and it´s always ASCII files.
>> >
>> >The only file that works is the ones ORA created.
>> >"Foreign" files get always rejected. I´ve tried with
>> >CR and CR/LF at the end of every line.
>> >
>> >Does ORA always have to be owner of the files, or
>> >is it enough to have rights on them?
>> >
>> >Is there a difference between a file created using UTL_FILE
>> >or a foreign plain ASCII file?
>> >
>> >Please help me?
>> >
>> >Regards,
>> >
>> >Mattias
>> >
>>
>>
>
>
Received on Mon Jun 14 1999 - 03:54:00 CDT