Re: file permission on file created by utl_file package.

  • From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
  • To: <Narendra.Admane@xxxxxxxxxxxxxxx>, <spikey.mcmarbles@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Mar 2005 19:41:46 +0200

Have you thought about issuing: 'host chmod' on the server?

Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "Admane, Narendra" <Narendra.Admane@xxxxxxxxxxxxxxx>
To: <spikey.mcmarbles@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
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@freelists=2Eorg [mailto:oracle-l-bounce@freelists=
> =2Eorg]
> On Behalf Of Greg Norris
> Sent: 09 March 2005 17:08
> To: oracle-l@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@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
>
> --
> //www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: