Since we use utl_file to read/write files from our application
directories(which are not owned by oracle), we need to set the permissions
on these directories so that Oracle has permission to read and write to
them.
However we run into problems because Systems Admin guys do not like :
1.
I typically set utl_file to /tmp/oracle/$ORACLE_SID. The /tmp dir (setuid bit set)
allows oracle to write and anyone to read. It protects users from overwriting Oracle
files. Nothing for the sysadmin to change :)
Gene
[EMAIL PROTECTED] 02/07/02 04:53AM
Since we use utl_file to read/write
ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: Unix permissions