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: Admane, Narendra <Narendra.Admane_at_capgemini.co.uk>
Date: Wed, 9 Mar 2005 17:28:33 -0000
Message-ID: <77898EE30049594BBC2E2AB2A9A54B2F8D2910@MISSBHXVS01.uki.capgemini.com>

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
Received on Wed Mar 09 2005 - 12:31:53 CST

Original text of this message

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