Re: UTL_FILE and default file permissions.....

Maxims solution will fit your request totally.

Another method (which does not answer your question, but maybe will please your needs) is
1) create a dedicated unix-group
2) add the 'application' and oracle-user to this group (not as primary group!)

3) make this group the directories group
4) chmod g+rw und +s on this directory
5) bounce the instance

HTH
 Martin

On Thu, Jun 11, 2009 at 18:57, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> Hi all,
>
>
>
> On my 10.2.0.3 RAC system, I’m running into a problem with default file
> permissions for files created via UTL_FILE.
>
>
>
> The problem is that the user’s server process inherits the default umask of
> the listener that spawns the server process. The listener (I assume)
> inherits the umask from the clusterware that starts the listener on node
> startup. Finally, the clusterware starts from /etc/init.d and inherits the
> default umask from (I assume) the init daemon. If I, as the Oracle user,
> logged in to a particular node, bounce the listener explicitly, the problem
> goes away, cause I have default umask of 022, which is what I want. (Files
> that default to rw-r—r--). But, listeners that are started by clusterware,
> either at boot, or explicitly via srvctl, inherit a different umask value.
>
>
>
> The question is, where can I set that umask value?
>
>
>
> Help? I can’t be the first one to have run into this…?
>
>
>
> -Mark
>

--
http://www.freelists.org/webpage/oracle-l