UTL_FILE Creating a file readable by everyone

From: Ben Ryan <ben_ryan_at_vancity.com>
Date: 1997/05/08
Message-ID: <5kt6i3$poa$1_at_sisyphus.tvinet.com>#1/1


Version Info.: Oracle 7.3.2.1.0 SCO OpenServer 5.0.2 PL/SQL 2.3

I am creating a file from within PL/SQL in the pub directory of the anonymous ftp Unix account. The file needs to be readable by all.

The file appears to appear to be created (at least on Unix) using the default setting of umask, resulting in the file only being readable by the Unix account owner (ie. oracle).

It appears that there is no way to set the file permissions via the utl_file package. Is that correct?

Ben Ryan - VanCity C.U.
Vancouver, B.C.
Canada Received on Thu May 08 1997 - 00:00:00 CEST

Original text of this message