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: Users vs. Schemas

Re: Users vs. Schemas

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Jun 2007 14:10:22 -0700
Message-ID: <1183151342.319686@bubbleator.drizzle.com>


Serge Rielau wrote:
> Mark D Powell wrote:

>> For explaining the differences between a USER and a SCHEMA to a
>> developer looking at the CREATE USER and CREATE SCHEMA command results
>> is a good idea.
>>
>> But is there a consensus of how best to describe PUBLIC?

> If one takes a step back, or a couple, things come into focus:
> Conceptually schemas and users are unrelated beyond the generic concept
> of object ownership, which is a property to most objects
> (such as tables).
> A schema is best described as a "directory" in a file system

Are you still using tape-sort technology too?

These may help:
http://www.psoug.org/files/files_vs_db.pdf http://www.psoug.org/files/why_databases.pdf

  > Now you can bring it back to a specific implementation. In this case
> Oracle where the mapping between user and schema is 1-0..1.
> Hence the confusion. It's like the relationship between mass (gram) and
> force (N).
>
> Cheers
> Serge

I wasn't confused before reading that last paragraph. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jun 29 2007 - 16:10:22 CDT

Original text of this message

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