UTL_FILE package

From: Ken Whitaker <kwhitake_at_moon.jic.com>
Date: 1997/03/15
Message-ID: <01bc30d5$d6fe7960$43cf87d0@kwhitake.jic.om>#1/1

I was testing in Oracle 7.3 on Sun Solaris 2.5 the UTL_FILE package that can read and write files.
The directory you intend writing to has to be in your INIT.ORA file (UTL_FILE_DIR=*) thus any directory you have access. The interesting thing happen when I wrote the file the permissions on the file were (you guessed it) oracle (owner) dba (group) mode 644 !!!! Well I quickly changed that "utl_file=/tmp" A side issue for anyone who wants to read the tkprof files you have to set the "_trace_files_public=true" as these files are created as oracle dba but mode 640

Anyway three questions:

Anyway to change the owner (even nobody) like web server would be ok as the unix user may not exist.

Anyway to change the mode (660) of the file so I could setup a separate group like (utl) etc.

Anyone want to think of any user being able to write to $ORACLE_HOME/dbs/init$ORACLE_SID.ini or

better yet the one of the oracle data files :-(

Well anyone has any comments on the subject ; have not called support on the issue but the answer should
be interesting,
kwhitake_at_moon.jic.com Received on Sat Mar 15 1997 - 00:00:00 CST