Hi, I am still not clear how to do this, I created 15 users in oracle...user1~user15. On the server site, utl_file_dir should be set to d:\dataware\sisfiles\user1..... to user2. I checked the property of d:\dataware\sisfiles, we have sis group have all the permission on the folder. How can I set all the 15 users assign them to sis group? I think my question is how all the users can get the r/w permission?
Thanks, Joan [EMAIL PROTECTED] wrote: > > Not an easy question. > > Set up a folder (directory) on the NT server called STUDENTS. Set your > utl_file_dir parameter to that folder. From the server's SERVICES panel, > stop and start the instance (so the parameter will take effect). Under > STUDENTS, create folders for each of your students and make them sharable. > You will need to have file sharing enabled on the server. To do that, > right click on the NETWORK NEIGHBORHOOD icon on the server. Pick > PROPERTIES and under that pick FILE AND PRINT SHARING. Tell it that you > want to be able to give others access to your files. From the student's > client machines, attach each student's folder as a network drive. You'll > probably want to make it so that they will automatically reconnect on > logon. > > > Joan Hsieh > <joan.hsieh To: Multiple recipients of list ORACLE-L > @tufts.edu> <[EMAIL PROTECTED]> > Sent by: root cc: > Subject: utl_file_dir question > > 04/08/2002 > 11:13 AM > Please > respond to > ORACLE-L > > > > 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: > 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).
