-
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.
HTH
Jim
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|