UTL_FILE and Unix Group Privs

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Thu, 13 May 2004 10:26:32 -0700 (PDT)
Message-ID: <20040513172632.10047.qmail@web20730.mail.yahoo.com>

Help!
I am trying to run the following simple test: declare

file_id utl_file.file_type;
begin

file_id := utl_file.fopen('/home/charlotte/report','test','w'); end;
/
I have created a unix group called appgroup. oracle is a member of appgroup. The above PL/SQL works if:

drwxrwxrwx 2 charlotte appgroup 96 May 13 18:12 report or
drwxr-xr-x 2 oracle appgroup 96 May 13 18:12 report

But! It does not work for:

drwxrwxr-x 2 charlotte appgroup 96 May 13 18:12 report

ERROR at line 1:

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 4

I don't understand why not. oracle is a member of appgroup and the directory is writeable by appgroup group. In fact if I log in using the oracle unix account, I can manuall create a file in this directory.

The O/S trace shows:

gettimeofday({1084468047, 557093}, NULL) = 0 access("/home/charlotte/report/test", F_OK) = -1 ENOENT (No such file or directory) statfs("/home/charlotte/report/test", 0xbfff1220) = -1 ENOENT (No such file or directory) open("/home/charlotte/report/test", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0666) = -1 EACCES (Permission denied) gettimeofday({1084468047, 559298}, NULL) = 0

I'm not sure exactly what the problem is. Is there anyway I can use UTL_FILE using Unix group privileges or do I either (a) have to make oracle own the directory, or (b) make it publically writable Thanks for any info
- Charlotte

Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu May 13 2004 - 13:09:55 CDT