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.
Have you thought about issuing: 'host chmod' on the server?
Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "Admane, Narendra" <Narendra.Admane_at_capgemini.co.uk>
To: <spikey.mcmarbles_at_gmail.com>; <oracle-l_at_freelists.org>
Sent: Wednesday, March 09, 2005 7:28 PM
Subject: RE: file permission on file created by utl_file package.
>
> Thanks,
>
> Other approaches are out of question as pro*c or manually editing through
> chmod command both are not suitable for me
>
> Other approaches if any are more than welcome=2E
>
> Kind Regards,
> Narendra
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists=2Eorg [mailto:oracle-l-bounce_at_freelists=
> =2Eorg]
> On Behalf Of Greg Norris
> Sent: 09 March 2005 17:08
> To: oracle-l_at_freelists=2Eorg
> Subject: Re: file permission on file created by utl_file package=2E
>
> Your umask setting can only filter out permissions which would
> otherwise be set by default=2E 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=2E In short, you need to find another way=2E=2E=
> =2E
> the current approach simply won't work=2E
>
> On Wed, 9 Mar 2005 15:40:43 -0000, Admane, Narendra
> <Narendra=2EAdmane_at_capgemini=2Eco=2Euk> wrote:
> >=0D
> > Hi Gurus,
> >=0D
> > 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=2Ee=2E
file
> > is created with rw-r--r--=2E I am looking forward to create the file
with
> > rwx-r-xr-x (755 permission)=2E
> >=0D
> > Can you please suggest me any way to create the file with execute=0D
> > permission in first place please
> --
> http://www=2Efreelists=2Eorg/webpage/oracle-l
>
> This message contains information that may be privileged or confidential=
> and is the property of the Capgemini Group=2E It is intended only for the
=
> person to whom it is addressed=2E If you are not the intended recipient,
=
> you are not authorized to read, print, retain, copy, disseminate, =
> distribute, or use this message or any part thereof=2E If you receive
this=
> message in error, please notify the sender immediately and delete all =
> copies of this message=2E
>
> --
> http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 10 2005 - 11:49:32 CST