| UTL_FILE file permission prob. [message #370610] |
Thu, 06 January 2000 13:08  |
Zoe Marcous
Messages: 2
Registered: January 2000
|
Junior Member |
|
|
Hi everyone,
I have two unix servers & databases that use UTL_FILE.
On ServerA I can read files created with UTL_FILE, but on ServerB I cannot. All the settings appear to be the same:
ServerA
Oracle 7.3.4.1
init.ora utl_file_dir = *
umask = 022
file permissions: rw-r--r--
ServerB
Oracle 7.3.4.0
init.ora utl_file_dir = *
umask = 022
file permissions: rw-r-----
I also login as the same user on both servers. Any suggestions would be greatly appreciated!
Thanks,
Zoë
|
|
|
|
| Re: UTL_FILE file permission prob. [message #370616 is a reply to message #370610] |
Fri, 07 January 2000 12:55  |
Bill Hoffman
Messages: 2
Registered: November 1998
|
Junior Member |
|
|
File I/O operations perform with UTL_FILE are done by the Oracle user. The Oracle user is the owner of the files that make up the database and the owner of the processes that make up the database instance. Ex: A UNIX userid, ORACLE7, is used to create and run an Oracle instance, all files written by UTL_FILE are owned by user ORACLE7. If UNIX userid JSMITH wants to read the files JSMITH must be given permissions in UNIX to read files created by ORACLE7.
If you look at the permissions set on server A and server B you will see that the owner and UNIX group members only can read files written by UTL_FILE on server B, anybody can read files created by UTL_FILE on server A. So your problem lies within the UNIX permissions.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
