Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: User vs Schema

Re: User vs Schema

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Fri, 22 Oct 1999 16:14:14 GMT
Message-ID: <q30Q3.147$p%6.4183499@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:14:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US