Re: User vs Schema

Gee, 4 repeats and still incomplete...

From Oracle Docs:

'Associated with each database user is a schema. A schema is a collection of schema objects. Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, procedures, and packages. This chapter explains tables, views, sequences, synonyms, indexes, and clusters.
Schema objects are logical data storage structures. Schema objects do not have a one–to–one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database. The data of each object is physically contained in one or more of the tablespace’s datafiles. For some objects such as tables, indexes, and clusters, you can specify how much disk space Oracle allocates for the object within the tablespace’s datafiles.'

A user is one who has been granted access to the database ....

HTH,
John Greco

"Didier LENQUETTE" <didier.lenquette_at_steria.fr> wrote:

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

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Oct 22 1999 - 11:53:28 CDT