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 to be
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
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
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
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
-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.name,1,instr(i.name,'/',-1)),
substr(i.name,instr(i.name,'/',-1