Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: file permission on file created by utl_file package.

Re: file permission on file created by utl_file package.

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 10 Mar 2005 19:41:46 +0200
Message-ID: <011801c52598$724972c0$e300a8c0@user12344>


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-l
Received on Thu Mar 10 2005 - 11:49:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US