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

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE-Package

Re: UTL_FILE-Package

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Mon, 14 Jun 1999 09:54:00 +0100
Message-ID: <3764c0d1.0@145.227.194.253>


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

Original text of this message

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