Schema Concepts 101 [newbie]

From: David Thom <davidt_at_npsinc.com>
Date: Fri, 30 Apr 1999 08:57:50 -0500
Message-ID: <7gccre$6t$1@uuneo.neosoft.com>

How are schemas intended to be used in Oracle8?

Apparently, a schema is equivalent (tied to?) to an individual user, so does one user have access to the schema objects in another user's schema?

Can schemas be setup which are accessible by groups of users?

Is there a "global" schema to contain schema objects which can be used by all users? I see references to a PUBLIC schema, but it's not an option when I use the Table Wizard to create a new table, for example.

[and is all this described anywhere in the Oracle8 Documentation? If so, I sure can't find it!]

Thanks!

David Thom Received on Fri Apr 30 1999 - 08:57:50 CDT