Title: RE: utl_file_dir and 9i
Raj
Thanks
for that. I notice that even using CREATE DIRECTORY method, it it still not
posible to specify a parent directory and then have access to sub directories.
Each directory must be specified in a CREATE DIRECTORY
statement.
In our
case, as we need
Title: RE: utl_file_dir and 9i
John,
In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY' rather than UTL_FILE_DIR ... firstly because a directory can be created dynamically, so to adda new sub-directory you don't have to bounce the instance.
Plus instead of '*', you can
Good points, also consider the security issues that exist because of 'util_file_dir=*'.
With that, any user that can run a procedure and write (or overwrite) files in
locations that should be accessible only by oracle.
[EMAIL PROTECTED] 03/14/03 07:08AM
John,
In 9i, Oracle is recommending
True, but any DBA who puts utl_file_dir=* into their parameter file
should be hung, drawn and quartered anyway! Just imagine what the
effect is - you've now given people rights to open system01.dbf, write
to it and close it. Hmm, could that cause any problems? :)
Pete
Controlling developers is
Which is why I want to know if in 9i I can specify a top level directory
John
-Original Message-
Sent: 14 March 2003 14:19
To: Multiple recipients of list ORACLE-L
Good points, also consider the security issues that exist because of
'util_file_dir=*'.
With that, any user that can run a
Title: RE: utl_file_dir and 9i
The answer is still NO
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-Original
Title: RE: utl_file_dir and 9i
Pete,
At-least that way to can verify that your backup and recovery scenario's are up-to-date 8:)
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD
Precisely
But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an
unacceptable parameter value?
- Kirti
-Original Message-
Sent: Friday, March 14, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
True, but any DBA who puts utl_file_dir=* into
Nah, can't do that! It would make our training courses that use it too
difficult to set up! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
-Original Message-