Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is the difference between a user and a schema ?
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