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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
