What is difference of user and schema?

Question:

>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
>

Answer:

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
 
 

Hosted by www.Geocities.ws

1