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