Re: Create 1 or multiple databases for class

Sunny Siu wrote:
>
> We start using Oracle 7.2 for a class of 60 students this summer semester.
> Each student in the class is going to create its table and program in
> embedded SQL/C.
>
> option 1. Create database for each student.
>
> option 2. Create just one database for the whole class,
>
> --------------------------------------------------------------------
> Question 1. What are the pros and cons of option 1 and option 2?
>
> Question 2. In option2, can each student create table with the same name,
> like "CREATE TABLE LAB1 ...."? How about writing programs
> to access the database?
>
> Question 3. Any security issue I need to pay attention in option 2?
>
> Your suggestion is appreciated.
>
> --
> --Sunny Siu
> Unix system admin., ACS
> University of Texas at Arlington
> siu_at_uta.edu

You should go ahead with option 2. You need ONLY one DB. Provide each student with unique Oracle login ids. Each student can create objects with the same names in their respective schemas. Received on Fri Jun 14 1996 - 00:00:00 CEST