Re: UTL_FILE Package

Until/if Oracle changes this, why don't either of you write a small shell script, C program, or whatever language you have on your server to change the perms for you after the files are created? If you're developers, I would expect you to have this knowledge.

AlexJent wrote:
>
> Your Said:
> =========================================================
> All the files that are written using this function are created under
> oracle
> ownership.
> Is there any way to change the file ownership automatically to the user
> who
> activates the function each time the file is created?
> =========================================================
>
> We have been struggling with this package also....
>
> Unfortunatley, the answer appears to be NO. The utility is run by the
> Oracle shadow process and therefore file created are owned by Oracle.
> Even more distressing in a production environment is that Oracle
> recommends that users/developers only have read access to the UTL_FILE
> directories. What this means is that you cannot even clean up your own
> garbage.... It can only can be done by a privledged user! BUMMER!
>
> One cannot even delete the file that one created.....
>
> We (developers) need a method to clean up our own trash without stressing
> out our DBA's and system admin types to make serious use of this package
> in a production environment.....ARE YOU LISTENING ORACLE????
>
> Alex Jentilucci - Consultant
> Information System Dynamics, Inc
> Minneapolis, MN 55323
> Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com
>
> E-Mail Work: jentilucci_at_notes.seagate.com
> Home: AlexJent_at_aol.com
  Received on Sun Jan 26 1997 - 00:00:00 CST