Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: multiple databases on the same server?

Re: multiple databases on the same server?

From: John Seitz <seitz_at_pobox.com>
Date: Fri, 02 Apr 1999 13:58:22 GMT
Message-ID: <3704CD1D.91816DF6@pobox.com>


We have the same problem at work. We just made each group its own UserName and Password. Just make sure that you don't give DBA rights to any of the groups. It takes a lot longer to setup the users since you have to pay attention to rights but it makes the database a lot easier.

John

George wrote:

> Does anyone know if it is possible to create multiple separate databases on
> the same server?
>
> I'm trying to use Oracle 8.0.5 in a classroom (running on Solaris). I would
> like to split the students into groups and have each group manage (or at
> least access) their own private database that can't be accessed by students
> in the other groups.
>
> Is this possible? From what I know, this sounds like each group would need a
> separate Oracle instance SID.
>
> Thanks for any info,
>
> George
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 02 1999 - 07:58:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US