• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2112
  • Last Modified:

UTL_FILE Unix file permissions

Oracle 8.1.6  Sun Solaris.
When UTL_FILE supplied packages creates a file its permissions are "rwxr-xr-x"
How can I change this default to "rwxrwxrwx" ?
0
peledc
Asked:
peledc
  • 3
  • 2
1 Solution
 
dbalaskiCommented:
Hi,

This can be changed by resetting the oracle instance owner (presumably the oracle account)  umask.   Since the unix account of the oracle instance is the owner of the server process, these will be passed on to the process.  .
Set the umask to 777  for the"rwxrwxrwx" premissions  before starting the instance and then it should work.

sincerely,
dBalaski
0
 
peledcAuthor Commented:
Wouldn't this have any effect on the Oracle instance in any known way?
0
 
peledcAuthor Commented:
Wouldn't this have any effect on the Oracle instance in any known way?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
peledcAuthor Commented:
Wouldn't this have any effect on the Oracle instance in any known way?
0
 
dbalaskiCommented:
Hi,

No,   it won't effect the way the instance runs.   remember, umask utility is only used to set the file mode creation  mask (permissions).
So, in this case, any new files created by  the oracle OS account, ie:such as trc files , dumps files,  new file generated by the UTL_FILE, etc)..     In fact, this is Oracle's recommended solution to that problem.

Sincerely
dBalaski
0
 
harel_dayanCommented:
go to the place of UTL_FILE_DIR parameter and type
chmod 777 *
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now