Re: User vs Schema

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 22 Oct 1999 12:01:18 -0700
Message-ID: <3810B47D.DA0144A4@us.oracle.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 Fri Oct 22 1999 - 14:01:18 CDT