Re: User vs Schema

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Fri, 22 Oct 1999 16:15:50 GMT
Message-ID: <W40Q3.148$p%6.4184295@France.EU.net>

Hi !

A schema is a facility to create table, view grant in a single transaction!

Moreover, in term of language, schema and user are synonymous except in one point : a user can have have no table, that is to say no schema.

Conclusion a schema is an user with tables and some other objects !

Regards.

Norazman Abu Sahir <norazman_at_ti.com> a écrit dans le message : 381009F1.34FBEEE1_at_ti.com...
> I realized I was confuse with the term "USER" and "SCHEMA"
> Even while using TOAD to login it put these 2 terms together ie :
> user/schema.
> 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
>
Received on Fri Oct 22 1999 - 11:15:50 CDT