Re: Solaris, O8i, utl_file file permissions

In article <3ABB59A6.2F5FC933_at_usgs.gov>, Brian Peasland <peasland_at_usgs.gov> writes
>It's obvious that UTL_FILE is not looking at your .profile and the umask
>defined there. If you want to change the file permissions, then you'll
>have to code it. For instance:
> BEGIN
> <UTL_FILE routine to make the file>;
> <change the file permissions>;
> END;
>
>You can use one of the more common methods to accomplish the changing of
>file permissions. Something like this can be performed with a call to an
>external C program, or by passing something through a pipe and having a
>program pick up the contents of the pipe and changing the file
>permissions.
>
>HTH,
>Brian

Thanks for your help.

After much fumbling around it suddenly dawned that utl_file uses the umask permissions set by the user that starts the *listener* - on our development machine the listener had been started by someone who has a umask of 077. So, although the files were created as owned by Oracle, they weren't using the Oracle user umask settings.

Andy

>Andy Hardy wrote:
>>
>> Hi,
>>
>> We're using utl_file to write files, but the file permissions are always
>> set to rw for Oracle only - so no-one else can read them!
>>
>> The Oracle user uses the Korn shell, and the .profile does have a umask
>> of 022, so it *should* work?!?!
>>
>> Our production system, running on HP-UX, has no such problems and the
>> file permissions are as expected.
>>
>> What should I be looking at?
>>
>> Andy
>> --
>> Andy Hardy. PGP ID: 0xA62A4849
>> ===============================================================
>
 

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================