DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2001

    Question 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.

  2. #2
    Join Date
    Jan 2002
    Up s**t creek
    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!

  3. #3
    Join Date
    Jan 2001

    Both Installs are Under The Same User

    The umask is 022

  4. #4
    Join Date
    Jan 2003
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.