Re: PLEASE HELP !

Andrea,

Build one database with different schemas for each user. When they log in, they'll only have access to their own data.

You'll have to decide whether to use UNIX or NT depending on a variety of factors, but if you have the available resources, I'd go with UNIX (multiple users performing multiple tasks).

Regards,

David A. Barbour
Oracle DBA, OCP

Andrea Oracle wrote:
>
> Hi all,
>
> Our trainer needs to build training database/s, she is
> asking the following questions:
>
> 1. use Sybase or Oracle as the database server?
> We have some projects using Sybase databases, and
>
> old training database is on Sybase.
>
> 2. build the database on Unix vs NT platform?
>
> 3. She wants each trainee has his/her own
> database(!!!), since she doesn't want one use to see
> other user's data. And she said in Sybase it's really
> easy to do this, she has a script that can create
> multiple databases. Is it doable (please give some
> tip or script), or is it necessary ???
>
> Any idea will be greatly appreciated!!!
>
> Andrea
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrea Oracle
> INET: andreaoracle_at_yahoo.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: David A. Barbour
  INET: dbarbour_at_nucentrix.net

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