Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Users vs. Schemas
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?
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.orgReceived on Fri Jun 29 2007 - 16:10:22 CDT