Re: UTL_FILE

"rob" <rob_at_dsdelft.nl> wrote in message news:9r5q76$9vu$1_at_news.tudelft.nl...
>
> > but the UTL_FILE_DIR parameters ( init.ora ) have to be initialize to
the
> directory
> > you want allow Oracle to create the file or you can choose a larger
option
> with
> > positioning UTL_FILE_DIR = * if you don't where you to create the files
> ( it's not
> > a good solution i think )
>
> No it's not. Never put UTL_FILE_DIR=* in init.ora. It allows all oracle
> users that have access to utl_file package to edit all files on the server
> as if they are user oracle. You can even edit oracle datafiles, init.ora,
> etc.
>
> Rob.
>
>
Also AFAIK utl_file_dir=* (or any wildcard for that matter) doesn't work, [Quoted] you have to include individual directories separated by ;

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 24 2001 - 10:36:43 CEST