>****snip****
>schema
>A named collection of objects, such as tables, views, clusters, procedures, and packages, associated with a particular user.
>************
>
>I guess they break it down to what is available to a particular user...
>
>
>- Brian
To be precise, all database "objects" (such as tables, views, ....) belong to a particular user.
All the objects that belong to a particular user are said to be in that user's schema.
A user may have permissions to objects in another user's schema, and even have views that reference objects in another user's schema. The views are in their schema, the tables the views refer to are in another.
As Mark has said, in an real-world scenario, you would typically create a "user" who is the 'Application Owner' and create the tables, views etc. you need under that user account (= in the 'Application Owner' schema).
Clear as mud ;)
Les
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only