I typically set it to /tmp/oracle/$ORACLE_SID for each db that requires it. Never
leave it *.
Gene
>>> [EMAIL PROTECTED] 12/03/01 07:40AM >>>
>if I set UTL_FILE_DIR = *
>would there be any security issue ?
In a word yes...this allows read/write access to *all* directories and there
is bound t
ipients of list ORACLE-L
> Subject: RE: UTL_FILE_DIR problem
>
>
> In particular,
>
> declare
> f utl_file.file_type;
> begin
> for i in ( select name from v$datafile
> order by file# desc ) loop
>f := utl_file.fopen(
> substr(i.nam
In particular,
declare
f utl_file.file_type;
begin
for i in ( select name from v$datafile
order by file# desc ) loop
f := utl_file.fopen(
substr(i.name,1,instr(i.name,'/',-1)),
substr(i.name,instr(i.name,'/',-1)+1),
'W');
utl_file.fclose(f);
end loop
>if I set UTL_FILE_DIR = *
>would there be any security issue ?
In a word yes...this allows read/write access to *all* directories and there
is bound to be particular ones you don't want people to see.
-Original Message-
Sent: 03 December 2001 11:40
To: Multiple recipients of list ORAC
It seems to me, I remember something like this. If I do remember correctly,
you need the execute permissions for the directory, so it would need to be
775.
Terry
-Original Message-
Sent: Monday, December 03, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I got one prob
Hi all,
I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.
I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message sayin