Re: User vs Schema

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Sat, 23 Oct 1999 06:59:32 GMT
Message-ID: <6EC14873F507D3119B8C0090273C43490C5709@jdasoftware.com>

Rob

It's actually a little bit more than that. The schema is the set of objects and
privileges belonging to a user, but since there's a one to one mapping between
users and schemas anyway, it's not worth worrying too much about the exact
definition.

Pete

rob van laarhoven wrote:

> >All I know schema is collection of objects and user is "the one" who
> >have access to that object.
> >
> >Any better explanation to make me clear ?
> >Is it a user A always means owner of schema A?
> >
> >TIA
> >
> The set of objects _owned_ by a user account is called the user's
schema. It
> is possible to create a user that is not able to login to the
database. Such
> a user account can be used to create a schema without the user being
able to
> login.
>
> Rob

Received on Sat Oct 23 1999 - 01:59:32 CDT