Re: utl_file_dir question

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

tday6_at_csc.com 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> <ORACLE-L_at_fatcity.com>
> 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: 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:
> INET: tday6_at_csc.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: 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).