Re: utl_file_dir question

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).