RE: UTL_FILE_DIR problem

I typically set it to /tmp/oracle/$ORACLE_SID for each db that requires it. Never leave it *.

Gene

>>> Kevin.Thomas_at_calanais.com 12/03/01 07:40AM >>>
>if I set UTL_FILE_DIR = *
>would there be any security issue ?

In a word yes...this allows read/write access to *all* directories and there is bound to be particular ones you don't want people to see.

-----Original Message-----
Sent: 03 December 2001 11:40
To: Multiple recipients of list ORACLE-L

Hi all,

I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.

I have set UTL_FILE_DIR to : /customer/ShopA and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA When I execute the PL/SQL job through SQLPLUS, I hit error message saying that I can't write to the directory. the /customer/ShopA directory permission is set to 664. Let's say owner is A, and the group is A1

Can I tell the program to access the directory and write to the file as another user ?
If I'm not wrong, the program will try to write into the directory using oracle unix account.
Note : I don't want to set the write permission to other group. I have tried to include oracle in A1 group using secondary group, but it couldn't work.

Can somebody tell me how to let oracle write into the directory and the file as well without
changing the directory / file permission.

if I set UTL_FILE_DIR = *
would there be any security issue ?

Any help will be greatly appreciated.

Thanks & Regards
Herman

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Herman Susantio
  INET: sherman_at_bcsis.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Thomas, Kevin
  INET: Kevin.Thomas_at_calanais.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).