Re: Setting UTL_FILE default output file permission???

From: Al <al_at_work>
Date: Tue, 29 Sep 1998 12:23:14 -0400
Message-ID: <6ur1pa$k873@piper.ncr.pwgsc.gc.ca>

You need to set umask in thge .profile of the account that runs the oracle processes

ie.

umask 622

LYee853344 wrote in message <19980926104539.29386.00002232_at_ng145.aol.com>...
>
>Hi,
>
>I have a PL/SQL program that outputs a flat file using UTL_FILE. The file
gets
>created with permission - RW- R-- ---, but I want it to be - RW- R-- R--.
We
>changed the ORACLE DBA userid to default to -RW- R-- R-- and recycled the
DB,
>but it didn't work. Does anyone know how to set this up? Any help would
greatly
>be appreciated, because I'm stuck!!
>
>Thanks, Leslie Yee
>
>P.S. We're running SCO Unix. Database version 7.x
>
Received on Tue Sep 29 1998 - 11:23:14 CDT