UTL_File file permissions
I have some odd behavior in my development area. We have both 9.2 and 8.1.7 oracle homes on our development box in a unix environment. I have two packages in a 8.1.7 database that creates a file using the utl_file package. The files are both created in the same directory on the unix box. The one file has permissions of -rw-r--r-- and the other file has the permissions -rw-r-----. How is this possible? The packages use the same syntax to create the file. In production on an 8.1.7 database the file is being created as -rw-r--r--. Does anyone know why in the same database, in the same directory, why there would be different permissions for the different files. I want -rw-r--r-- for both files in development. Thanks.
Are both Oracle installs under the same user? If not check the umask setting for the unix accounts.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Both Installs are Under The Same User
May be you have to do
_trace_files_public = true
in the init.ora
But not sure.
Click Here to Expand Forum to Full Width