UTL_File file permissions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: UTL_File file permissions

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    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
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Both Installs are Under The Same User

    The umask is 022

  4. #4
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    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