Re: What is the difference between a user and a schema ?

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Fri, 4 Oct 2002 22:10:36 +0200
Message-ID: <anksf5$81o$1@news.hccnet.nl>

As soon as you create any object as user MARY she has become a schema owner: user+object==>schema

Peter

"Monty" <mmontreaux_at_hotmail.com> schreef in bericht news:6284dd3.0210041141.3b55ae1f_at_posting.google.com...
> Hi, I'm more than a little confused by the apparent similarities and
> differences between what is a user and what is a schema.
>
> I have installed on my home computer Oracle 8i Enterprise.
>
> Loading up "Oracle Enterprise Manager" I note that the default install
> has created a user called "SCOTT" and a schema called "SCOTT". When I
> create a new user called "MARY" I note that I only have a new user
> called "MARY", but no new schema called "MARY".
>
> So what is the difference?
> And if I wanted to create a new schema called "MARY" how would I do
> it?
> And why would I want to do it?
>
> Thank you
> Monty
Received on Fri Oct 04 2002 - 15:10:36 CDT