Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: file permission on file created by utl_file package.
Your umask setting can only filter out permissions which would
otherwise be set by default. Since Oracle won't attempt to create the
file with execute permission in the first place (not does any other
*nix program with which I'm familiar), no setting you can provide will
yield the desired result. In short, you need to find another way...
the current approach simply won't work.
On Wed, 9 Mar 2005 15:40:43 -0000, Admane, Narendra
<Narendra.Admane_at_capgemini.co.uk> wrote:
>
> Hi Gurus,
>
> I am creating the file using utl_file package, but even though I set the
> umask to 022 the file is created without execute permission i.e. file
> is created with rw-r--r--. I am looking forward to create the file with
> rwx-r-xr-x (755 permission).
>
> Can you please suggest me any way to create the file with execute
> permission in first place please
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 09 2005 - 12:11:23 CST