Schema and User 101

Schemas and users are frequently used interchangeably as if they were the same thing. For the most part, that’s ok. In Oracle the concepts are so tightly coupled that thinking of them as the same thing is not really that far wrong. 

In reality, a user is a database account that is given a password and permissions. A schema is a container, or namespace, for containing schema objects. Schema objects are things like tables, views and indexes.

In Oracle, when a us