Re: Solaris, O8i, utl_file file permissions

From: Brian Peasland <peasland_at_usgs.gov>
Date: Fri, 23 Mar 2001 14:11:50 GMT
Message-ID: <3ABB59A6.2F5FC933@usgs.gov>

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

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
> ===============================================================
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Mar 23 2001 - 08:11:50 CST