Opening up permissions on utl_file output

[sjwales]

The developers in our organization have an application that is writing to the utl_file directory. (HPUX, 11.11, Oracle 9.2.0.2).

Permissions on the files are 600. Of course, ownership of the file is oracle. The users want to be able to access the file.

Umask for oracle is 027 - I had thought that might fix it.

Anyone able to offer some insight?

Thanks

stephen.wales@riotinto.com

 

[myersg]

are you getting a write error or just your users cant read the file?

if its a write error you need to add the path to your ini file to "authorize" utl_file to write to the directory

 

[sjwales]

It's a read error.

The files are being written as permissions 600, owner is Oracle.

I need to log in and do a chmod all the time so that they can read it.

stephen.wales@riotinto.com

 

[gman57]

You can achieve this by setting the umask of the OS user to 002. This, I feel, is insecure because any files created by this user will have permissions like 664. Since you will need to open up the directory to allow other users to access the files it might not be a good idea to have such lax permissions. Another approach, which I prefer, is to set the oracle umask to 002 and restart your database listener and make sure that you specify your TNS host name when you log in because if you don't then the listener is bypassed and your files will have very restrictive permissions.

I hope this helps.