RE: utl_file_dir question

Joan,

The oracle user, whoever owns the installation, needs to have r/w on the directory. I've only done it in Unix, but it's the same on NT, I believe.

PS - here's a link to the online docs, they should help you out too:

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/ a76936/utl_file.htm#1000704

-----Original Message-----
Sent: Monday, April 08, 2002 12:23 PM
To: Multiple recipients of list ORACLE-L

Thanks Arslan, I appreciate your timing response. Now the last question, for the r/w permission on the directory, if I created all the users in oracle, like user01,user02... I am not sure how to grant permission to the directory?

Joan

Arslan Bahar wrote:
>
> 2. like this
> utl_file_dir = g:\oracle\utl_file,
> g:\oracle\utl_file\change_svceng, g:\oracle\utl_file\change_usage
>
> 3. server
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, April 08, 2002 6:13 PM
>
> > I have couple question. We need to set up 15 trainer
> > in the training room by tomorrow for a pl/sql class. I need to set
> > up utl_file_dir for them. This is NT environment. question 1: If I
> > create 15 users in oracle, do I need to ask Nt admin to create
> > system users for them as well?
> > 2: It should be 15 different directories for each of them. How to
> > set it in int.ora?
> > 3: Since the training room are remote access to server. The
> > utl_file_dir will write to local or server?
> >
> > Those are sound pretty easy question. I never set this up before and
> > they want it now. I will check the manual as well.
> >
> > Thanks in advance,
> >
> > Joan
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joan Hsieh
> > INET: joan.hsieh_at_tufts.edu
> >
> > 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: Arslan Bahar
> INET: abahar_at_ford.com.tr
>
> 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: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

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: Sutton, Reed
  INET: rsutton_at_fcg.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).