Re: 9i Newbie : spfile, sql-backtrack questions

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Fri, 12 Apr 2002 10:12:35 +1000
Message-ID: <Hypt8.36607$uR5.85317@newsfeeds.bigpond.com>

Knut,

As all users can read or write files found in the UTL_FILE_DIR I'd imagine not having on the fly definition is a security decision. Most sites would not want people to be able to give themselves access to OS directories from inside the database. Perhaps Oracle will implement a method that allows us to choose if we want this ability by setting a parameter while logged in with sysoper privileges.

BTW: I have worked around this previously by defining a bunch of symbolic links all pointing to the same directory and then listing them all against UTL_FILE_DIR in the init.ora. Later when I need to access another directory I just redefine one of the symbolic links to point to it.

Kind regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3CB5F7C5.7991AD6B_at_mytoys.de...
> > Scope SPFILE writes only to the SPFILE, and only takes effect when you
restart
> > the database. Only needed for the few remaining static parameters (like
> > UTL_FILE_DIR).
>
> BTW, does anybody know why UTL_FILE_DIR still is not system or session
> modifiable?
>
> Regards,
>
> Knut
Received on Thu Apr 11 2002 - 19:12:35 CDT