Re: UTL_FILE File Permissions

This is aworkaround:

I think you can set the setgid bit on the directory. So any file created in the directory will have the groupowner of the directory.

eg:
you write to usr/out/t.txt
-> set the ugid on out (chmod g+s out)
-> determine to which group everyone belongs who needs access to the t.txt file (for example users)
-> make users the owner of out (chgrp users out)

Hope this helps. You can also after creating the file do a change mod of the last created file. The sh-script will be than sth like this: # start creation script
sqlplus ...
chmod 777 usr/out/*.txt # or to other perms

Or better to cp the file to a ftp-location where everyone can retrieve the file.

M.Balaji wrote:

> Hi,
> I am creating a txt file in Oracle using the UTL_FILE package on a
> Unix Server. The File is being created by the Oracle Shadow Process
> with the Read and Read write permission to ora users. Is there any way
> we can create the file with specified permissions so that who ever
> have access to the directory can access the file. Please let me know
> if there is any workaround for this.
> Thanks and Regards
> M.Balaji
>
Received on Mon Jan 07 2002 - 07:05:54 CST